The BASETONUM function converts a number of the specified base into a number in base 10.
BASETONUM(convert-string, base)
convert-string: The string value representing the number to be converted. convert-string must contain only numbers and letters that apply in the base of the number being converted.
base: number value representing the current base of the number to be converted. base must be in the range 1 to 36.
Notes
This function returns a number value and can properly be used in a formula containing other number values. Some other spreadsheet apps return a string value.
Examples |
|---|
=BASETONUM(“3F”, 16) returns 63, the decimal (base 10) equivalent of the hexadecimal (base 16) value 3F. The quotation marks are required whenever a letter is included in convert-string. =BASETONUM(1000100, 2) or =BASETONUM(“1000100”,2) returns 68. =BASETONUM(-1000100, 2) returns an error, as the minus sign is not a valid part of convert-string. =-BASETONUM(1000100, 2) returns -68. =BASETONUM(7279, 8) returns an error, because the digit “9” is not valid in base 8. |