Apple Numbers '08 Manual do Utilizador descarregar pdf (Página 267)

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

1 2 ... 262 263 264 265 266 267 268 269 270 271 272 ... 294 295

Sem comentários

Apple Numbers '08 Manual do Utilizador Página 267