Nokia 9500 User Guide - Page 50

Converts a text argument to a number., Converts text to uppercase.

Get Nokia 9500 - Communicator Smartphone 80 MB PDF manuals and user guides View all Nokia 9500 manuals
Add to My Manuals
Save this manual to your list of manuals

Page 50 highlights

Sheet 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-2005 Nokia. All Rights Reserved. 50

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
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 © 2004-2005 Nokia. All Rights Reserved.
50