Apple Numbers '08 Manuale Utente Scaricare il pdf (Pagina 244)

244 Chapter 12 Dictionary of Functions

LEFT

The LEFT function retrieves the specified number of characters from the left end of a

string.

LEFT(text, [length])

Â text: A text expression.

Â length: Optional; the number of characters to retrieve. If omitted, the leftmost

character is retrieved.

LEN

The LEN function counts the number of characters in a string. The count includes all

spaces, numbers, and special characters.

LEN(text)

Â text: A text expression.

The LN function calculates the natural logarithm of a number, the power to which e

must be raised to produce the number.

LN(number)

Â number: A positive number, a numeric expression, or a reference to a cell containing

a positive numeric expression.

Examples

LEFT("one two three", 2) returns "on".

LEFT("abc") returns "a".

Examples

LEN("12345") returns 5.

LEN(" abc def ") returns 15, the sum of the six letters plus the three leading, three trailing, and

three separating spaces.

Examples

LN(2.71828) returns approximately 1, the power to which e must be raised to produce 2.71828.

LN(EXP(1)) returns 1. LN is the inverse of the EXP function.

1 2 ... 239 240 241 242 243 244 245 246 247 248 249 ... 294 295

Nessun commento

Apple Numbers '08 Manuale Utente Pagina 244