S h e e t

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.

Copyright   2005 Nokia. All Rights Reserved.

50