In this article, we will learn about how to use the DECIMAL function in Excel.
DECIMAL function in excel is used to convert text representation of numbers of a given base to decimal numbers (base =10).
The table shown below shows you some of the most used base & their radix Alpha - numeric characters
|Binary||2||0 - 1|
|Octal||8||0 - 7|
|decimal||10||0 - 9|
|hexadecimal||16||0 - 9 & A - F|
|hexatridecimal||36||0 - 9 & A - Z|
The DECIMAL function converts the number of a given radix to a number of radix 10 (decimal).
Number : value to be converted to decimal.
Radix : or base of the given number. Range from 2 to 36 (integers).
The decimal value is obtained from the number of radix 2 as shown in the above gif.
Let’s understand this function using it in an example.
The numbers & their Radix or base value. We need to convert these numbers to decimal value which is base 10.
Use the formula:
A2 : number
B2 : radix or base
Values to the DECIMAL function is provided as cell reference.
The decimal representation of 101011 of base 2 is 43 of base 10.
Now copy the formula to other cells using the Ctrl + D shortcut key.
As you can see here the decimal representation of the numbers from the numbers.
Hope you understood how to use DECIMAL function and referring cell in Excel. Explore more articles on Excel mathematical conversion functions here. Please feel free to state your query or feedback for the above article.
50 Excel Shortcuts to Increase Your Productivity
How to use the VLOOKUP Function in Excel
How to use the COUNTIF in Excel 2016
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.