Right, Roman – Apple Numbers '08 User Manual

Page 267

Advertising
background image

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".

Advertising