Browsing all articles tagged with Excel

UPPER Excel Formula

Author Zaheer    Category Formulas     Tags ,

MS Excel is just one software programs that is manufactured as well as developed by MS Corporation that let the users calculate, format, and arrange data by using formulas in a spreadsheets. Spreadsheet is a type of system that’s broken up by columns or rows. MS Excel is well-matched with other application product sets offered by the Microsoft Company. Multiplan is first mere soft programs similar to Microsoft Excel. First software released was in 1982.

Software programs are organized info through the structures of programs, operating systems, utilities and application that let the personal computer work. It’s written and organized by computer programmer with right and important code and instruction in various exceptional languages of computers. It includes licensing requirements and agreements as well. Software program documentation has complete information on limitations, design details, features as well as capabilities of application software or system. Software manual comes along with printed documents or added software part on Disk as well.

MS Excel software programs are spreadsheet tools that have the ability to carry out calculations, integrate info through any kind programs and analyze data. It is comprise of organizational bodies known as work books. Standard workbook comprises of work sheets or chart sheets. Work sheet or spread sheets carry out data storing and organizing, calculations, presenting graphics and control like web page. Therefore, it’ considered flexible since it includes million of cells.  The cell is accountable for keeping formula that functions to compute and communicate some other applications like database. Spread sheets present and accumulate data as well. Worksheets or spreadsheets are typically employed in engineering as well as business calculation along with some arithmetic functions. MS Excel has several uses in terms of business and engineering. An application of Visual Basic is the key force and the language for powerful programming behind the capabilities of MS Excel. These are the following uses of Excel in business as well as in engineering.

  • Problem optimization utilizing the crystal ball and solver
  • Software design
  • Model and team integration
  • Quick charting and analysis
  • Automated generation report
  • Advanced modeling and numerical simulation
  • Data analysis and sorting
  • Information control and command
  • Constraint project monitoring
  • Database control and communication
  • Integration of real time to different applications
  • Multiple programming for language with C code or DLL and Fortran

Most company time and funds are not invested through the development of software tools from its progress within computer languages with the functions of the MS Excel. Companies consequently use the computer languages by maintaining the large population of staffs due to its succession. The programmers often use Microsoft Excel function and formulas and one functions is UPPER function.

Conversion of the Uppercase into Lowercase:

With conversion, utilize Excel lower function converting the entire uppercase letters into lowercase letters within the text string. The function is located within the Text category in the dialog box of the Insert Function. For instance, uppercase text – CLYDE E. WASHINGTON; the function formula will be – “LOWER(A1) that resulted to – clyde e.washington.

Using the Excel Upper Function:

The upper function in MS Excel converts the precise text to the uppercase. It automatically returns the specific text with lowercase letters replaced by the equivalent uppercase result. Uppercase character or without equivalent uppercase changes.


  • Study the upper syntax – “UPPER(test_text)”
  • Identify “test_text” like the potential conversion of text to the upper case. It could be a string or a reference.
  • Proper and lower functions are similar when you compare it with the upper function. Proper switches the first mere letter of every word to the upper case. If possible, the user must have to capitalize the first string character like each of the letter following a character, which is not merely letter.
  • Study and learn several of the basic and simple examples for the proper use of the UPPER function. For example: UPPER (“456789”) = 456789. Notice that character has no equivalent uppercase, therefore, no changes are to be made. UPPER(“TEXT TEST”) = TEXT TEST. There are no needed changes since the text is already in uppercase. UPPER(“text test”) = TEXT TEST. Each of the letters is converted into uppercase.
  • Examine and observe several uses of the Upper function in Excel on cells that have mixed text like B2 = “Upper Test Case” and C2 = “Def456”. Thus, the UPPER(B2) is the mixture of cases showing each evaluated character separately and thus if needed, it is converted to the uppercase. In the case of UPPER(C2) = DEF456, wherein ‘e’ and ‘f’ are capitalized although numbers are not affected by the UPPER function.

How To Export A Microsoft Excel Table To Microsoft Word

To write down a document tables can be needed to present data for various purposes. There are powerful features to create tables in Microsoft Word. You can create tables according to your need and insert data in the table. You can format the table according to your need. However, if the data are kept in Excel worksheets, you can use the data in the Word document in various ways. If you feel it is time consuming to create new tables and entering data into the table in the Word document, then you can import the data from the Excel Spreadsheet.

Simple way to export a Microsoft Excel table to Microsoft Word is copy-paste. Open the Excel file then activate the worksheet where the table is. Select the range of data. You can do it by dragging the mouse or pressing the Shift + Arrow keys of the keyboard. After selecting the range or the table copy it by pressing the button from the Clipboard group in the Home tab, or you can use the CTRL + C from the keyboard to copy the selection.

Then open the Word document where you want to set the table. Set the cursor in the position where you want to paste the table. Then click on the Paste button in the Clipboard group. The data will be pasted with the table. To keep link with the source table you should choose the Paste Special from the list that will appear after clicking the down arrow of the Paste button. You can choose any of the option Paste or Paste link. To view the table as a still image select Paste; then select Picture (Enhanced Metafile) or Bitmap from the list. To size the image click on it, then use the mouse pointer to drag the sides of the image.

In many cases, you may need to present the updated excel data in the table. For this the table should be linked with the source file. When a change will be made in the source file, changes will be viewed in the word table also. To do this select the Paste link, then choose the Excel Worksheet Object and click ok. The table will be pasted in the document with the link to the source file. If a change is occurred in the source file, the changes will be viewed in the table. This type of link is very helpful where you will have to work with continuously changeable data. There is another way to do this. Just paste the table by clicking on the Paste button or pressing CTRL + V. There a small icon will appear at the bottom of the table. Click on it and select the option “Keep source formatting and link to excel”. To view as picture select the Paste as Picture option. To make the table more attractive, choose the option “Match destination table style and link to Excel.” Select the table by clicking on the top left symbol of the table. Then click on the Design tab. Then select the table style that you like. There are many lucrative styles in the Design tab. To delete the table, select the table the go to the Layout tab, click on Delete then Delete table. The table with data will be deleted.

You can import the object from the Word also. Open the Word file; then click on the Insert tab. Click on the Object in the Text group. Then click on the Create from File tab. Then click on Browse and select the excel file from where you want to import the table. Double click on the file, the file will be selected. Then check the Link to file check box. Then click ok. The table will be pasted there. If any changes occur in the excel file the changes will be viewed in the Word table also. To view just the link to the source table, check the Display as Icon check box. Then click ok. This will insert an icon in the Word document, by clicking on the icon you can enter into the source file. To know more things about using excel table data, associated help files of the Office software can help you.

How To Print Tables And Charts in Microsoft Excel

Microsoft Excel is a popular spreadsheet program. Chart is one of the most important features of the Excel program. One can adjust the chart according to his or her need. Here, necessary instructions are given to print charts and tables in Microsoft Excel 2007 and 2010 versions.

In 2007 version, if anyone wants to print a chart including the worksheet data, then he or she should follow the following instructions –

  • Enter into the worksheet where the chart is.
  • Go to the View tab, click on the Page Break Preview or Page Layout from the Workbook Views.
  • Drag the chart on the page where you desire to print.
  • If anyone wants to change the size of the chart, then he can do any of these. He can resize the chart by clicking on the chart and dragging the sizing handles. He can also go to the Format tab and enter the height and width of the chart.
  • To print multiple charts in one page, one can resize the charts.
  • Click on the worksheet, then on the MS Office Button, then on Print. By default, under Print what, active sheets are selected. It will be better to see the preview of the page by clicking on the Preview button.
  • By default, the gridlines will not appear on the printed page. To print the gridlines, go to the Page Layout, then Sheet Options and tick the Print box under the Gridlines.

To print any chart without the worksheet data following steps should be followed –

  • Click on the chart you wish to print.
  • Then click on the MS Office Button, then click Print.
  • To see the preview of the printed page, click on the Preview button.

Setting the page options to print a chart 

  • Click on the Launcher button from the Page Setup on the tab of Page Layout.
  • Now from the Page tab you should select necessary buttons and specify the orientation, print quality, paper size, and page number.

Setting page margins to print a chart 

  • Click on the Margins from the Page Setup which is on Page Layout tab.
  • You can use any predefined margins. To do that click the option that you like.
  • For custom margins, go to the Custom Margins and enter your required sizes in the Right, Left, Bottom, and Top boxes.
  • To set the margins of header and footer, go to the Custom Margins and set the sizes.
  • To view the preview of the printed page click on the Print Preview. Set the margins in the print preview. To do that click on the Show Margins and drag the margin handles.

Setting the print quality 

  • Click on the chart which you need to print.
  • Click on the Launcher from Page Setup which is on Page Layout tab.
  • Select the print quality that you want, view the preview of the printed page by clicking on the Print Preview.
  • Then click on Print to print the chart.

Printing a worksheet in Excel 2010 

  • Click on the desired worksheet.
  • Click on File then click on Print. To use keyboard shortcut you can use CTRL+P. Here you should remember that the preview will be displayed in black & white unless it is configured.
  • By clicking on the Next Page or Previous Page one can preview the relative pages.
  • Do the following for setting the printing options. Select the desired printer by clicking the drop-down box which is under Printer. Select the desired options under Settings. For printing entire worksheet click on the necessary option from the scale options.
  • If anyone is interested to print a certain portion of a worksheet, then the range should be selected. For printing an entire worksheet, just activate the worksheet by clicking it.
  • Then click Print.

Most of the common instructions to print tables and charts in Microsoft Excel are described here. To know more elaborately it is better to visit the Microsoft site. The associated help file can help you to find out necessary instructions to perform a task using Excel. You can get the help files by pressing the F1 key.

How To Email A Chart From Inside Microsoft Excel

Author Zaheer    Category Guides     Tags , ,

Chart is an important feature of the Excel program. A chart can easily represent a group of data which may need hundreds of words if anyone wants to explain it. A chart can be accompanied by related data where necessary or you may want to send just only the chart. In normal emailing system, it is not usual to send a chart or a graph as a message. In many cases, you will have to edit the html code of the email to send a chart or an image as a message.

Microsoft Office programs like MS Excel and MS Word have options to send charts or images including data as messages to the recipient. This option will make your email-sending task easier. Just not only that it will make the task easier but also it will make the message more attractive. If anyone wants to send a chart to his clients, then he should follow the following instructions.

  • Open the Excel file where the chart is. For a new one, open a new Excel file and save it.
  • Write down necessary data in the excel file and create the chart.
  • Resize the chart if you need and set it in proper position where it will be suitable.
  • Now save the file.
  • See the Quick Access toolbar, if there is already the Mail Recipient tool, then ok. If the tool is not there, then click on the drop-down arrow and click on More Commands. Now from the Choose Commands list, choose All Commands and click on it. From the list find out the Send to Mail Recipient and click on add. Then click OK. The Mail Recipient button will be added in the quick access toolbar.
  • Another way to add the Mail Recipient button in the toolbar is through the Office Button. Click on the button then click on Word Options, then click Customize from the left list. Now follow the above process to add the button to the toolbar.
  • Now you should establish the internet connection to send an email to the recipient.
  • Save the file and click on the Mail Recipient button. Computer will start task to establish a connection between your Excel program and the internet through an email account. Set any email account such as with its password. The computer will check the email account; then it will send a sample message to that account.
  • After establishing the connection, start the Microsoft Outlook and follow the instructions as the program prompts. Some buttons will appear on the task bar. The Outlook will be configured with the email account that you entered earlier.
  • Now for convenience and to avoid problems, close all the open programs. Open the Excel program. Establish the internet connection. Select the worksheet where the chart and other necessary data are. Click on the Mail Recipient button from the quick access toolbar.
  • You will be prompted with two options whether you want to send the whole workbook as attachment or to send the sheet as a message. Choose the one which you like, for this time choose As Message and click OK.
  • Mailing layout will appear. In the To box write the email address of the recipient. The program will take the excel book name as the subject of the email. Change the subject if necessary.
  • There is an introduction box; his will appear as the heading of the recipient’s message box. Write down something which will describe the whole message properly.
  • Now the chart and other necessary data are ready for sending to the recipient.
  • Above the To box there is a toolbar. There is a tool Send this Sheet at the left side of the toolbar. Click on the button, the message including the chart will be sent to the recipient.
  • For convenience, test the process by sending an email to your optional email address and check the email box whether the message has been arrived properly.

Following the above instructions anyone can send charts or images to the recipients he wants. To know more about this, search the help files and visit the Microsoft site.

How To Export A Microsoft Excel Table To Microsoft Access

There are many ways to share data from excel to access and from access to excel. The most simple and easy way is to copy and paste all the information from one worksheet into some new Microsoft access database. Another option is to import an excel sheet into access database. Many other applications help in transfer data from one document to another. One of the very useful approaches is data analyzer.

You only need to load data in the excel sheet by using analyze it with excel option in the access menu. You can use importing, exporting and linking data techniques for transferring purpose. By the time, you are done with creating your document in Microsoft excel, click save option to save your file in Microsoft excel. This option is listed above in the listing and formatting tool bar. Now the next step is to start Microsoft access and open the option of database that you want to import from excel sheet.

After these initial steps, click import option from the file menu. The import option is available in the import dialogue box. However, you need to choose appropriate version of Microsoft excel file that you are importing into Microsoft access and click the OK button. Some Microsoft access files don not import some specific versions of excel sheet. You can also use the option of appending your file or an already created document and transfer it to another workbook. However, if your goal is import data from excel, you can try other options. In order to store some data or all data from one or more excel sheet into Microsoft access, the best option is to import the content of worksheet into a new or existing Access database. During the process of importing data, Microsoft access creates a duplicate copy of your data or file and it makes you available on time. However, this alteration does not change the source excel file.

In case when you want to import excel file into Microsoft access, you might face many similar scenarios that already had happened with many people. You might need to move all your data into access sheet. You can start by importing all your relevant data from one excel worksheet and save it into the Microsoft access. When a managers receives reports from his employees in excel format, and he wants to merge the file with an existing database, he updates all the content with database of Microsoft Access. Some websites are also offering this service of transferring from excel to access. These website and their designs help a business to expand from physical market to electronic market. Many people have expanded their business and are now dealing with e commerce. Some organizations that are working on small scales require only one permanent or contracting Office features. That develops a document for them or for their company. Further applications and functions of a Microsoft office are handled to other jobholders such as graphic designer or some technician of information system. Various categories of Microsoft Excel help customers to reach directly to their area of interest.

Sometimes managers need to convert all their data into access format when their employees send them huge data in excel format. Managers usually merge the reports with existing database and update the content of the new database. Converting data from excel to access is also required during the process of developing an application where you are required to write codes and import data from excel.

In case if you are importing data from an excel sheet for the very first time, you must know few key points. You should never look for any way to save your excel data sheet into an access database. There is no option in Microsoft excel that allows you to save or create functionality into database with excel data. Before starting the import operation, do not forget to open an access database file. You must need to open a new database file especially in case of creating a new document. If you are not familiar with tables in excel sheet, see the option of about tables. There are many other ways to save and protect your excel sheets and workbooks.

How To Upgrade Microsoft Excel 2003 to Microsoft Excel 2010

Microsoft Excel 2010 is more attractive in layout. However, the tools and commands are not in places where they were in 2003 versions. Many users will face problems to find out necessary commands to perform their tasks. The commands are not missing, but they are hidden. You will have to add the necessary commands to your customizable toolbar which is now called ribbon in the latest versions of the Office software.

Collect the Microsoft Excel 2010 software with necessary license keys. You can buy the software disk from a software shop or you can download the software from online. After collecting the software, you should uninstall the previous version, as this is recommended. However, you can run multiple versions of office software in the same computer. To uninstall a program you should go to the control panel, then go to add/remove programs. From the program list, select the program and click on the change/remove button. The program will be removed. It is better to restart the computer after uninstalling a program.

Multiple versions can be installed in the same computer. For this, you will have to follow the sequence of installation. For example, if the versions Office XP, Office 2003, and Office 2010 have to be installed in the same computer; then at first install the Office XP, then install the Office 2003, then install the Office 2010. Earlier version should be installed first. Otherwise the program will not work properly. If the system is a Terminal Server, then Microsoft does not allow to run multiple versions of MS Office. To run several versions you will have to disable the Terminal Services.

If a version is uninstalled from the computer, then the program will be installed again maintaining the same order to keep the software work correctly. Some difficulties may occur in the shortcuts. Office XP, Office 2000, and Office 97 use same shortcuts. It is suggested by the Microsoft to add version numbers to the shortcuts. This will help to distinguish the versions. To know more about these procedures you can visit the Microsoft sites.

As the differences between the versions 2003 and 2010 are significant, it will be better to read a guide to clarify the layout and differences of the Excel 2010. For the convenience of the users here are 5 resources which can help them to learn about the Excel 2010. The resources are, Menu-to-ribbon Guide, Mapping Workbook, Migration Guide, Switch to Excel, Upgrades’ Guide etc. Some information about the Excel 2010 has been discussed below from the Migration Guide.

The users of Excel 2003 will obviously ask the question where the toolbar buttons and commands are. For your convenience, you can go to the File tab, then go to Help, then click on Getting Started under Support. A web page will be opened, click on the links that you want. Clicking on any 2003 command you will be able to see the exact location of the command in 2010 version. Menus and toolbars are replaced with ribbons which at the top of the program window. There are different commands and buttons organized into groups in each tab. After starting the Excel 2010 Home tab appears. Most commonly used commands are in the Home tab. New users should be attentive about the commands which are in the groups of Cells and Editing. Necessary commands for formatting columns, rows, and sheets, deleting, and inserting are there.

To open, create, print, save, protect, preview, convert, or send files click on File tab. Use the Insert tab for adding Pivot Tables, charts, hyperlinks, header and footer, excel tables etc. When you will need to set page margins then go to the Page Layout tab. There you will be able to set page breaks and print area also. For finding functions, defining names, and troubleshooting formulas go to the Formulas tab. For checking spelling and revising the workbook the user should go to the Review tab. View tab is for arranging windows, switching between the worksheet views etc. You can make your tasks easier by customizing the ribbon. To do this right-click the ribbon group, then click on Customize the Ribbon. Commands can be added to the groups also. There are several add-ins in Excel 2010, just follow the guides to manage the add-ins.

How To Creating New Excel Workbook And Storing It To A Network Drive as A Macro Enabled Workbook

Excel sheet is a very useful and beneficial type of workbook. It offers many advantages including the flexibility to make data tables, charts, and graphs. You can also perform lot of calculation by entering values in the excel spreadsheet. Excel worksheet offers many advantages to the user. It is alike a workbook where you can enter, edit and save all your work. It also offers the opportunity to make pie and bar charts at the same time with the same values. Once you open an excel workbook you should immediately save it in the window and then start your work.

You can also make a personal workbook. When you open the excel sheet, you should save the personal macro workbook that opens with the excel sheet. Save the personal, excel workbook in any folder within the window. You should also know the art of using and creating the macro.

Macro is nothing but a useful piece of information that helps excel in making the automatic processes. You should use the macro very carefully. First, try to buy the macro from a trust source. It can cause lot of trouble for your hardware if the macro is not right. Once the macro has been created in your computer, store the personal excel workbook in the macro. It is also necessary to have a tab with the name developer on it. This tab should be in your keyboard. Try to make the tab visible in your excel sheet. After having this tab, you can save the personal workbook in the macro. Macro recorder is also a good option. Macro recorder can format the text that you have entered in the excel sheet and make the text bold and highlighted.

First enter the text in the Cell, and then press developer it will start to record the macro. After recording, click ok. After doing this, press buttons CTRL+B to make the text bold. Bold formatting of the text is also recorded in the macro. After saving the macro, click the tag stop recording on the developer tab. Developer tab is actually present in code group. After this close the entire workbook and excel spreadsheets. A message with the notification of saving the changes will appear. Save all the changes by clicking yes button. Now save the personal notebook. When you will open the excel spreadsheet again, personal notebook will not appear because it is hidden now in macro workbook. For opening the personal notebook, you need to follow a different method.

When word macro is used in Microsoft excel workbook, it simply refers to set of instructions that gives brief information to automate some process within the spreadsheet. It helps you in sorting out or cleans some data from spreadsheet with a single click. It also helps you in performing variety of similar tasks and duties. Macro saves its users’ time and effort but users have to be very careful with the running program of excel and macros. It is always good to verify the source of macro spreadsheet. The source of spreadsheet should be trustworthy. Another option is available on your computers that are called personal.xlsb that allows you copy all of your macro work to a special workbook. The usual thing that happens mostly is that mostly macros only work in workbooks that contain them. For instance, if you create a macro in excel sheet, it will work only in Microsoft excel. It is suitable only in case when you do not need a macro workbook in other formats. However, if you store your excel in a workbook on a particular computer, it is always available and open in that computer in any workbook whenever you start your same computer. In case, if you are personal workbook is loaded in your computer but you cannot see it because of some error or any other default, you can click personal.xlsb for your assistance. All you required is to open a view tab in the window group option and click the option of unhidden. All saved macro data can be edited in your computer by first unhanding the personal workbook. This prevents the accidentally deleting and making of unwanted changes in your excel workbook.

How To Protect A Worksheet And A Workbook

Author Zaheer    Category Guides     Tags , ,

Microsoft company reorganized large portion of Microsoft excel when they launched 2007 version. This helps in the usage of computer memory in an effective manner. You can also perform lot of calculation by entering values in the excel spreadsheet. Excel worksheet offers many advantages to the user. It is alike a workbook where you can enter, edit and save all your work.

There is no option in Microsoft excel that allows you to save or create functionality into database with excel data. All Microsoft excel versions can be run in all computers with little storage memory. However, in order to export a worksheet from one Excel workbook to a brand new workbook. You might need to purchase excel memory. One of the most important thing is to protect your Microsoft excel, access and other spreadsheets. This will prevent other users to add any irrelevant material or to delete your material from excel work sheet and from other workbooks. It is also essential that not all users should be able to unprotect or unlock the workbook programmatically. The best option is to lock your document by a password. You can set a password so that a user cannot move or change your sheets around. In addition, you can also set password to protect workbook’s windows.

One way to name and protect a workbook is writing workbook, then put a dot and write sheet name. The name can be in 8-bit format and in Unicode format. You can read that and make necessary adjustments in your excel and other workbooks. The method for creating new cells is more or less like the same that you use in creating rows. You can also make a personal workbook. When you open the excel sheet, you should save the personal macro workbook that opens with the excel sheet. It can cause lot of trouble for your hardware if the macro is not right. Once the macro has been created in your computer, store the personal excel worksheet in the macro. Macro recorder can format the text that you have entered in the excel sheet and make the text bold and highlighted. When you will open the excel spreadsheet again, personal notebook will not appear because it is hidden now in macro workbook. For opening the personal notebook, you need to follow a different method. The source of spreadsheet should be trustworthy. Another option is available on your computers that are called personal.xlsb that allows you copy all of your macro work to a special worksheet. In case, if you are personal workbook is loaded in your computer but you cannot see it because of some error or any other default, you can click personal.xlsb for your assistance.

However, you must also keep in mind that protecting a workbook and worksheet does not stop users from editing cells. In order to protect your confidential data, you must also need to protect your worksheets. To avert a user from by mistake or intentionally changing, affecting, or harming your confidential data from workbook, you need to defend assured worksheet or manual elements by using or not using a password. You can also remove the protection at any time from a worksheet as desirable. The elements of worksheet and workbooks should not be confused with the workbook level password security. The best advantage of using element protection is that it can protect a workbook from all those users who have malicious intentions. It is advisable to protect your whole document and workbooks by using a security password. This makes it easy for authorized users to view your document. Now only authorized users can modify or view data in your worksheets and workbooks. Adding a password to unlock or edit the sheet is optional. After applying only an optimal password does not ensure that all sensitive data is protected. In order to get an optimal security, the best option is to select a workbook with a secure password that will help in safeguarding your data and worksheets from authorized users’ access. You also need to remember your password. This is very essential, as you might need all your confidential information at any time in your working hours. Forgetting a password will waste your time or may lead to serious consequences.

BIN2HEX Excel Formula

Author Zaheer    Category Formulas     Tags , ,

To convert binary numbers to hexadecimal number, or converting base 2 numbers to base 16 you can use BIN2HEX function in Excel. The language used in computer programming are binary but are greatly represented by hexadecimal numbers. Hexadecimal characters are composed of numbers from 0-9 which are followed by the alphabets A to F.

Before using function, first load and install the Analysis ToolPak. This is through selecting the Add-Ins on the Tools menu. Next, select from the list on Add-Ins list the Analysis ToolPak and click on OK. There are also available instructions and setup in the program.

The syntax of the function or the series of arguments for the BIN2HEX function is BIN2HEX (value [, precision]). The value on the function is the binary number which is to be converted while the precision can be left blank. Precision here represents the minimum digits of the return value.

You can try the function be opening a blank Excel worksheet. Input the function =BIN2HEX (11111011, 4) on the A1 cell. This will return to 00FB wherein 1111 in binary form is F in hexadecimal and 1011 is a binary and is B in hexadecimal.

Take note that if the value is an invalid binary number or contains 10 bits or more an error will occur which is #NUM. A negative character will be ignored and the BIN2HEX function will return to a hexadecimal number with ten characters. In addition, if the places are not an integer, non-numerical, and are negative an error will occur.

To view the results and to view the formulas with the results you can press Ctrl+` (grave accent). You can also do this by clicking on the Formulas tab and in the Formula Auditing group select on the Show Formula button. All the Best!

BIN2OCT Excel Formula

Microsoft Excel is commonly used by engineers for their speedy and competent computation. Since engineers deal more on database, Excel program aid them to easily compute their systematic computation. With this, the common function used by engineers in Excel is the BIN2OCT.

BIN2OCT Description

This function changes a binary number to an octal number. The aspect that differ the two is the “base” that is being utilized. The common numbers are those that are utilized everyday, and these numbers are called base-10. When writing numbers, every place could contain one of the 10 numbers ??from zero till nine. In addition, binary is considered as base-2 but the required value is only two in each place; it is either zero or one. Octal is base-8, which is in every place must have eight values and the number is from zero up to seven. Only the binary numbers of up to nine digits can be altered through BIN2OCT, with an extra digit to the top tenth reserved for indicating the number sign (0 for positive and 1 for negative).

Function Format

The function formula of BIN2OCT is variable, which means you could place diverse things that suit your needs. Once a variable is in brackets square, this signifies it is not obligatory and not essential to be included.

= BIN2OCT (number, [places])


The [places] formula is the characters numbers to be utilized for the result. This is valuable for adding zeros to the outcome. Once [places] is blank, BIN2OCT uses the least characters number required.


=BIN2OCT(1110) – it changes binary 1110 to octal (16)

=BIN2OCT(1110, 3) – it changes binary 1110 to octal having 3 bits (016)

=BIN2OCT(110111010, 5) – it changes binary 110111010 to octal with 5 bits (00672)

=BIN2OCT(111111111) – it changes binary 111111111 to octal neglecting places (777)

Things to Keep in Mind for BIN2Oct Function:

  • In Microsoft Excel 2007 the function was alleviated from the Analysis ToolPak add-in. It can be used as standard.
  • In Microsoft Excel 2003, it is available if your program has Analysis ToolPak add-in.
  • Once the number has greater than 10 characters, then the most important number character is the sign bit. The magnitude bits are the 9 remaining characters.
  • Once the number is consist of 10 characters, the most essential bit signify sign bit for instance the first number, which could be negative or positive.
  • Once the number has more than 10 characters, the #NUM is revisited.
  • Once the number is greater than 0 two complement notations is utilized to represent number.
  • Once the number is great 0, the [places] neglected and the 10 number is returned.
  • Once [places] is not an integer then it is truncated.
  • Once [places] is not a figure the value is revisited.
  • Once [places] is greater than 0 the #NUM value appears.

These are some of the things to keep in mind in order to use BIN2OCT formula efficiently. In order to effectively use Microsoft Excel, you need to learn all its function, because with all these available functions you could use the program in very limited time and very efficient manner. Most of the function is the short cut method of computation.