Syntax
=DECIMAL(text, radix)Arguments
| Argument | Required | Description |
|---|---|---|
text | Required | The digits, like "FF" |
radix | Required | The base of the text, from 2 to 36 |
How to use DECIMAL
DECIMAL takes 2 required arguments. Type =DECIMAL( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=DECIMAL("FF", 16)Result =DECIMAL(111, 2)Result =DECIMAL("zap", 36)Result Related math functions
- COTReturns the cotangent of an angle given in radians.
- COTHReturns the hyperbolic cotangent of a number.
- CSCReturns the cosecant of an angle given in radians.
- CSCHReturns the hyperbolic cosecant of a number.
- DEGREESConverts an angle from radians to degrees.
- DIVIDEReturns one number divided by another, like the / operator.
- EVENRounds a number away from zero to the nearest even integer.
- EXPReturns e raised to the power of a number.
- FACTReturns the factorial of a number (1*2*3*...*number).