keep in mind javascript is required for full website functionality.
Welcome back to our regular blog of Excel functions from A to Z. Today we look at the DECIMAL function.
The DECIMAL function
This function converts a text representation of a number in a given base into a decimal number (base 10).
The DECIMAL The function uses the following syntax to operate:
The DECIMAL The function has the following arguments:
- text: This is required
- base: This is also mandatory and must be an integer.
It should also be noted that:
- The length of the string text Must be less than or equal to 255 characters
- the text The argument can be any combination of alphanumeric characters valid for the baseAnd it is not case-sensitive
- Excel supports a text Argument greater than or equal to 0 and less than 2 ^ 53. A text Argument that resolves to a number greater than 2 ^ 53 May result in a loss of precision
- base Must be greater than or equal to 2 (Binary or base 2) and less than or equal to 36 (base 36)
- a base Greater than 10 Use numeric values 0-9 And letters A-Z as needed. For instance, The base 16 (Hexadecimal) usa 0-9 And A-F, And the base 36 usa 0-9 And A-Z
- if any of the arguments are outside your limitations, DECIMAL May return the #ON ONE! O #VALUE! error value.
Please, see my example below:
Soon we will continue with our functions from A to Z of Excel. Keep checking: there is a new blog post every business day.
You can find a full page of feature articles here.
