Apple numbers Manuel D’Utilisation
Chapter 12
Dictionary of Functions
283
TRIM
The TRIM function removes extra spaces from text. TRIM removes all spaces before the
first character, all spaces after the last character, and all duplicate spaces between
characters, leaving only single spaces between words.
first character, all spaces after the last character, and all duplicate spaces between
characters, leaving only single spaces between words.
TRIM(text)
 text: The text from which you want to remove extra spaces.
TRUE
The TRUE function returns the Boolean value TRUE. It is included so you can use
spreadsheets created with some older spreadsheet applications. You can specify a
Boolean value of TRUE by simply typing “true” (without quotation marks) into a cell or
function argument.
spreadsheets created with some older spreadsheet applications. You can specify a
Boolean value of TRUE by simply typing “true” (without quotation marks) into a cell or
function argument.
TRUE()
 No arguments (but you must include the parentheses).
Notes
You can type the word TRUE into a cell or formula instead of using the TRUE() function.
You can type the word TRUE into a cell or formula instead of using the TRUE() function.
TRUNC
The TRUNC function truncates a decimal number to the specified number of digits.
TRUNC(number, [digits])
 number: A numeric expression indicating the number you want to truncate.
 digits: Optional; the number of digits of the result relative to the decimal point. A
 digits: Optional; the number of digits of the result relative to the decimal point. A
positive number represents digits (decimal places) to the right of the decimal point.
A negative number specifies digits to the left of the decimal point, which are
replaced with zeros. If omitted, 0 is used.
A negative number specifies digits to the left of the decimal point, which are
replaced with zeros. If omitted, 0 is used.
Examples
TRIM(" spaces spaces spaces ") returns "spaces spaces spaces".
Examples
TRUE() returns the Boolean value TRUE.
AND(1,TRUE()) returns the Boolean value TRUE.
AND(1,TRUE) behaves exactly like the preceding example.