Apple numbers User Manual

Page of 295
Chapter 12   
 Dictionary of Functions
267
 
RIGHT
The RIGHT function retrieves the specified number of characters from the right end of a 
string.
RIGHT(text, [length])
 text:  A text expression.
 length:  Optional; the number of characters you want to retrieve. If omitted, returns 1 
character.
  
ROMAN
The ROMAN function converts a number to Roman numerals.
ROMAN(number, [style])
 number:  The Arabic numeral that you want to convert. Must be nonnegative and less 
than 4000.
 style:  Optional; determines how strictly the classical rules for forming Roman 
numerals are applied:
0 (or TRUE, or omitted) uses the most strict classical rules. When a smaller numeral 
precedes a larger to indicate subtraction, the smaller must be a power of 10 and can 
precede a number no more than 10 times its size. For example, 999 is represented as 
CMXCIX, but not LMVLIV.
1 relaxes the strict classical rule by one degree. When a smaller number precedes a 
larger, the smaller need not be a power of 10 and the relative size rule is extended by 
one numeral. For example, 999 can be represented as LMVLIV, but not XMIX.
2 relaxes the classical rule by two degrees. When a smaller number precedes a larger, 
the relative size rule is extended by two numerals. For example, 999 can be 
represented as XMIX, but not VMIV.
3 relaxes the classical rule by three degrees. When a smaller number precedes a 
larger, the relative size rule is extended by two numerals. For example, 999 can be 
represented as VMIV, but not IM.
4 or FALSE relaxes the classical rule by four degrees. When a smaller number 
precedes a larger, the relative size rule is extended by two numerals. For example, 
999 can be represented as IM.
Examples
RIGHT("one two three", 2) returns "ee".
RIGHT("abc") returns "c".