DECIMAL
Converts a text representation of a number in a given base into a decimal number.
Math & TrigonometryMath Basics
What it does
Converts text of a given base (radix) to a decimal number.
Syntax
DECIMAL(text, radix)
Arguments
text(text) — String to convert.radix(number) — Base (2-36).
Examples
Hex to Decimal
Convert 'FF' base 16 to decimal.
FORMULA
=DECIMAL("FF", 16)RESULT
255
SAMPLE DATA
| A | |
|---|---|
| 1 | Hex |
| 2 | FF |