Apple numbers User Manual
284
Chapter 12
Dictionary of Functions
UPPER
The UPPER function converts text to uppercase.
UPPER(text)
 text: The text you want to convert to uppercase.
VALUE
The VALUE function converts a number formatted as text into a regular number.
VALUE(text)
 text: The text-formatted number you want to convert.
Notes
You’ll probably never need to use the VALUE function; Numbers converts numbers in
text automatically for you. The VALUE function is included so you can use spreadsheets
created with some older spreadsheet applications.
You’ll probably never need to use the VALUE function; Numbers converts numbers in
text automatically for you. The VALUE function is included so you can use spreadsheets
created with some older spreadsheet applications.
VAR
The VAR function calculates the sample (unbiased) variance of a set of values.
VAR(number, [number, . . .])
 number: One or more numbers or numeric expressions, or one or more references to
numbers or numeric expressions.
Examples
TRUNC(1.49,0) returns 1.
TRUNC(1.50,0) returns 1.
TRUNC(1.23456,3) returns 1.234.
TRUNC(1111.222,-2) returns 1100.
TRUNC(-2.2,0) returns -2.
TRUNC(-2.8,0) returns -2.
Examples
UPPER("a b c") returns "A B C".
UPPER("First") returns "FIRST".
Examples
VALUE("22") returns the number 22.
VALUE(RIGHT("The year 1953", 2)) returns the number 53.