TIME(hour,minute, second) Returns the serial number of a particular time.
TIMEVALUE(time,text) Converts a time in the form of text to a serial number.
TODAY( ) Returns a serial number of the current date.
TRIM(text) Removes spaces from text.
TRUE( ) Returns the logical value TRUE.
TRUNC(number, num_digits) Truncates a number to an integer.
TYPE(field) Returns a number which depends on the content of the
selected field.
UPPER(text) Converts text to uppercase.
VALUE(text) Converts a text argument to a number.
VAR(number1,number2,...) Estimates variance based on a sample.
VARP(number1,number2,...) Calculates variance based on the entire population.
VLOOKUP(lookup_value,table_array,col_index_num,...) Searches for a value in the leftmost column of a table and
returns a value.
YEAR(serial_number) Converts a serial number to a year.
Sheet
Copyright © 2005 Nokia. All Rights Reserved. 51