Nokia 9500 manual TIMEhour,minute, second TIMEVALUEtime,text TODAY

S h e e t

TIME(hour,minute, second)

TIMEVALUE(time,text)

TODAY( )

TRIM(text)

TRUE( )

TRUNC(number, num_digits)

TYPE(field)

UPPER(text)

VALUE(text)

VAR(number1,number2,...)

VARP(number1,number2,...)

VLOOKUP(lookup_value,table_array,col_index_num,...) YEAR(serial_number)

Returns the serial number of a particular time.

Converts a time in the form of text to a serial number.

Returns a serial number of the current date.

Removes spaces from text.

Returns the logical value TRUE.

Truncates a number to an integer.

Returns a number which depends on the content of the selected field.

Converts text to uppercase.

Converts a text argument to a number.

Estimates variance based on a sample.

Calculates variance based on the entire population.

Searches for a value in the leftmost column of a table and returns a value.

Converts a serial number to a year.

Copyright © 2004 Nokia. All Rights Reserved. 48