Syntax
=ROMAN(number, [form])Arguments
| Argument | Required | Description |
|---|---|---|
number | Required | A number from 0 to 3999 |
form | Optional | The style: 0 or TRUE classic, 1 to 3 more concise, 4 or FALSE simplified |
How to use ROMAN
ROMAN takes 1 required argument and 1 optional argument. Type =ROMAN( 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.
=ROMAN(499, 0)Result =ROMAN(499, 1)Result =ROMAN(499, 4)Result Related math functions
- RADIANSConverts an angle from degrees to radians.
- RANDReturns a random number from 0 up to (not including) 1, new on every recalculation.
- RANDARRAYReturns an array of random numbers; you choose the size, the range and whether they are whole numbers.
- RANDBETWEENReturns a random whole number between two numbers (both included).
- ROUNDRounds a number to a given number of digits, halves away from zero.
- ROUNDDOWNRounds a number toward zero to a given number of digits.
- ROUNDUPRounds a number away from zero to a given number of digits.
- SECReturns the secant of an angle given in radians.
- SECHReturns the hyperbolic secant of a number.