Converts a text representation of a number in a given base into a decimal number.
Den här funktionen fungerar likadant i Google Kalkylark som i Excel — samma syntax och argument.
DECIMAL(text, radix)The DECIMAL function takes a string representing a number and a radix (base) to return the equivalent decimal value. It supports bases ranging from 2 to 36. This is the inverse operation of the BASE function.
=DECIMAL("FF", 16)Resultat: 255
Converts the hexadecimal value 'FF' to its decimal equivalent.
=DECIMAL("1011", 2)Resultat: 11
Converts the binary value '1011' to its decimal equivalent.
The text string can be up to 255 characters long.