Home » Nokia Manuals » Mobile Phones » Nokia 9500 » Manual Viewer

Nokia 9500 User Guide - Page 48

ERROR.TYPEerror_val, INDIRECTreference, A1

Add to My Manuals
Save this manual to your list of manuals

Page 48 highlights

Sheet COUNTA(value1,value2,...) COUNTBLANK(range) DATE(year,month,day) DATEVALUE(date_text) DAY(serial_number) DDB(cost,salvage,life,period,factor) DEGREES(angle) ERROR.TYPE(error_val) EXACT(text1,text2) EXP(number) FACT(number) False( ) FIND(find_text,within_text,start_num) FV(rate,nper,pmt,pv,type) HLOOKUP(lookup_value,table_array,row_index_num,...) HOUR(serial_number) IF(logical_test,value_if_true,value_if_false) INDEX(reference,row_num,column_num) INDIRECT(reference,A1) INT(number) IRR(value,guess) ISBLANK(value) ISERR(value) ISERROR(value) ISLOGICAL(value) ISNA(value) ISNONTEXT(value) ISNUMBER(value) ISTEXT(value) LEFT(text,num_chars) LEN(text) LN(number) LOG10(number) LOOKUP( ) LOWER(text) MAX(number1,number2,...) MID(text,start_num,num_chars) MIN(number1,number2,...) MINUTE(serial_number) Counts how many values are in the list of arguments. Counts the number of blank cells within a range. Returns the serial number of a particular date. Converts a date in the form of text to a serial number. Converts a serial number to a day of the month. Returns the depreciation of an asset for a specified period using the double-declining balance method or some other method you specify. Converts radians to degrees. Returns a number corresponding to an error type. Checks if two text values are identical. Returns e raised to the power of a given number. Returns the factorial of a number. Returns the logical value FALSE. Finds one text value within another (case-sensitive) one. Returns the future value of an investment. Looks in the top row of an array and returns the value of the indicated cell. Converts a serial number to an hour. Specifies a logical test to perform. Uses an index to choose a value from a reference. Returns the reference of a text. Rounds a number down to the nearest integer. Returns the internal rate of return for a series of cash flows. Returns TRUE if the value is blank. Returns TRUE if the value is any error except #N/A. Returns TRUE if the value is any error value. Returns TRUE if the value is a logical value. Returns TRUE if the value is the #N/A error value. Returns TRUE if the value is non text. Returns TRUE if the value is a number. Returns TRUE if the value is a text. Returns the leftmost characters from a text value. Returns the number of characters in a text string. Returns the natural logarithm of a number. Returns the base-10 logarithm of a number. Returns a value either from a one-row or one-column range, or from an array. Converts text to lowercase. Returns the maximum value in a list of arguments. Returns a specific number of characters from a text string. Returns the minimum value in a list of arguments. Converts a serial number to a minute. Copyright © 2004-2005 Nokia. All Rights Reserved. 48

Section	Page
Nokia 9500 Communicator User Guide	1
Contents	3
For your safety	6
ABOUT YOUR DEVICE	6
NETWORK SERVICES	6
Shared memory	7
Enhancements, batteries, and chargers	7
Getting started	8
Installing the SIM card, battery, and memory card	8
Charging the battery	9
Switching the device on and off	9
Radios	9
Antennas	9
Access codes	10
First start-up	10
Keys and connectors	11
Communicator interface	11
Common actions in several applications	13
Cover phone	13
Display indicators	13
Keypad lock (Keyguard)	14
Volume control	14
Memory cards	14
Instructions in your device	15
Using the CD-ROM	15
Nokia support on the Web	15
Stickers in the sales package	15
Transferring data from other devices	15
Cover phone	16
Making a call	16
Answering a call	16
Options during a call	16
Writing text	17
Accessing the menu functions	17
Messages	17
Call register	18
Contacts	18
Shortcuts to the contacts list	18
Searching for, adding, and deleting contacts	18
Settings for the contacts	19
Speed dialing	19
Other functions	19
Profiles	19
Settings	19
Camera	20
Desk	21
Managing groups	21
Creating new groups	21
Telephone	22
Making a call	22
Answering a call	22
Speed dialing	22
Making a conference call	22
Viewing dialed, received, and missed calls	23
Sending DTMF tones	23
Setting the offline profile	23
Diverting calls	23
Call barring	24
Call, network, and phone line settings	24
Call settings	24
Network settings	24
Advanced settings	24
Voice mailbox settings	25
Log	25
Messaging	26
Messaging center	26
Writing and reading messages	26
Managing messages	27
Avoiding low memory	27
E-mail	27
Working online and offline	27
Changing the Internet connection	27
Writing and sending e-mail	28
Sending options	28
Retrieving e-mail	29
Reading and replying to e-mail	29
E-mail attachments	29
Changing e-mail replying and viewing preferences	29
E-mail account settings	29
Text messages	31
Sending options for a text message	31
Replying to text messages	31
Text message settings	32
Modifying message center settings	32
Managing messages on the SIM card	32
Picture messages	32
Multimedia messages	33
Creating and sending multimedia messages	33
Receiving multimedia messages	34
Multimedia message account settings	34
Fax	34
Setting sending options for a fax	34
Saving a received fax	35
Editing fax settings	35
Receiving faxes from a remote fax box	35
Special message types	35
Receiving operator logos	35
Receiving ringing tones	35
Receiving configuration messages	35
Receiving e-mail notifications	35
Opening password-protected messages	36
Viewing bookmark messages	36
Viewing configuration details	36
Renaming settings	36
Receiving provisioning settings	36
Cell broadcast	36
Web	37
Browser settings	38
Keyboard shortcuts for browsing	39
Contacts	40
Managing contact cards	40
Editing contact cards	40
Creating and editing contact card templates	41
My contact card	41
Sending contact cards	41
Sending a contact card	41
Creating and editing contact groups	42
Managing contacts saved in the SIM card	42
Copying and moving contacts to different databases	42
Contact card settings	42
Documents	44
Working with documents	44
Formatting documents	44
Inserting and editing objects	45
Viewing tables	45
Using templates	45
Sheet	46
Workbooks	46
Working with worksheets	46
Working with cells	46
Creating and modifying chart sheets	47
List of functions	47
Presentations	51
Viewing presentations	51
Viewing slide shows	51
Showing slide shows with a data projector	51
Creating presentations	51
Inserting tables	52
Working with different views	52
Outline view	52
Notes view	52
Slide master view	52
Calendar	53
Creating calendar entries	53
Calendar icons	53
Managing calendar entries	54
Calendar settings	54
Calendar views	54
Month view	54
Week view	55
Day view	55
Weekly time schedule view	55
Year schedule view	55
Anniversaries view	55
To-do lists view	55
Calendar files	55
File manager	56
Managing files and folders	56
Memory card security	56
Camera and Images	58
Camera	58
Taking a picture	58
Recording a video clip	58
Camera settings	58
Images	59
Viewing images	59
Editing images	59
Managing image files	59
Control panel	61
General	61
Date and time	61
Regional settings	61
Time page	61
Date page	61
Numbers page	61
Currency page	62
Device language	62
My own key	62
Display	62
Wallpapers	62
Enhancement settings	62
Data management	62
Application manager	62
Modifying installation settings	63
Setting Java application security settings	63
Camera folders	63
Backup	63
Memory	63
Messaging tools	63
Telephone	64
Profile settings	64
SIM access profile	64
Data call and fax call diverting (network service)	65
Data call and fax call barring (network service)	65
Messaging	65
Service message	65
Connections	65
Wireless LAN	66
Specifying wireless LAN settings	66
Creating a basic Internet access point for a wireless LAN	66
Cable setup	66
RealPlayer settings	67
Restore default IAP	67
Security	67
Device security	67
Defining device lock settings	67
Defining PIN code settings	68
Changing the barring password	68
Certificate manager	68
Managing certificates	68
Extras	68
About product	69
Location privacy	69
Location request log	69
HP printer selection	69
Service command editor	69
Internet setup	69
Setting up an Internet access point	69
Configuring advanced Internet access point settings	70
IP configuration page	70
Proxies page	70
Data call page	70
Script page	70
Other page	70
Setting up an Internet access point for a wireless LAN	71
Configuring advanced Internet access point settings	71
IP configuration page	71
Proxies page	71
WPA page	72
EAP page	72
WEP page	72
EAP modules	72
Modifying the EAP-SIM settings	72
Modifying the EAP-TLS settings	72
Modifying the EAP-PEAP settings	73
Modifying the EAP-LEAP settings	73
Configuring Internet connection settings	73
Selecting an Internet access point	73
Media applications	74
RealPlayer	74
Playing media clips	74
Adjusting media volume	74
Sending media clips	74
Music player	75
Listening to music	75
Managing music tracks	75
Sending music	75
Voice recorder	75
Opening the voice recorder	75
Recording a phone call or voice memo	76
Playing a voice recording	76
Sending a voice recording	76
Calculator	77
Making calculations	77
Using the scientific calculator	77
Saving numbers to memory	77
Setting the number format in Calculator	77
Clock	78
Using world clock	78
Using Alarm clock	78
Alarms and reminders	78
Cities and countries	78
Changing cities	78
Locating cities on the world map	78
Creating and editing country entries	79
Creating and editing city entries	79
Data and software management	80
Data mover	80
Backup	80
Data transfer	81
Sync	81
Nokia PC Suite	82
Installing applications and software	82
Installing Symbian software	83
Installing Java applications	83
Java	83
Java MIDP	83
Java PP	83
Connectivity	84
Wireless LAN	84
Setting up an ad hoc network	84
Cable connection	84
IP passthrough	84
Bluetooth	84
Bluetooth settings	85
Sending data with Bluetooth	85
Receiving data with Bluetooth	85
Pairing with a device	85
SIM access profile	86
Ending a Bluetooth connection	86
Checking the status of the Bluetooth connection	86
Infrared	86
Modem	86
Printing	87
Setting printing options	87
Defining page setup	87
Problems with printing	87
Managing mobile printing settings	88
Remote configuration (network service)	88
Creating a new configuration server profile	88
Data connections	89
Wireless local area network (wireless LAN)	89
Packet data (general packet radio service, GPRS)	89
High-speed data calls (high-speed circuit switched data, HSCSD)	90
GSM data calls	90
Connection manager	90
Personalizing your device	91
Cover selection keys	92
Shortcuts	93
General shortcuts	93
Application-specific shortcuts	94
Data transmission	99
Noise	99
Roaming	99
Electrostatic discharge	99
Dead spots and dropouts	99
Signal impairment	99
Low signal strength	99
Battery information	100
Nokia battery authentication guidelines	100
Authenticate hologram	100
What if your battery is not authentic?	100
CARE AND MAINTENANCE	102
Additional safety information	103
Operating environment	103
Medical devices	103
Pacemakers	103
Hearing aids	103
Vehicles	103
Potentially explosive environments	103
Emergency calls	104
Certification information (SAR)	104
THIS DEVICE MEETS INTERNATIONAL GUIDELINES FOR EXPOSURE TO RADIO WAVES	104

Match case Limit results 1 per page

COUNTA(value1,value2,...)

Counts how many values are in the list of arguments.

COUNTBLANK(range)

Counts the number of blank cells within a range.

DATE(year,month,day)

Returns the serial number of a particular date.

DATEVALUE(date_text)

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

DAY(serial_number)

Converts a serial number to a day of the month.

DDB(cost,salvage,life,period,factor)

Returns the depreciation of an asset for a specified period using

the double-declining balance method or some other method

you specify.

DEGREES(angle)

Converts radians to degrees.

ERROR.TYPE(error_val)

Returns a number corresponding to an error type.

EXACT(text1,text2)

Checks if two text values are identical.

EXP(number)

Returns e raised to the power of a given number.

FACT(number)

Returns the factorial of a number.

False( )

Returns the logical value FALSE.

FIND(find_text,within_text,start_num)

Finds one text value within another (case-sensitive) one.

FV(rate,nper,pmt,pv,type)

Returns the future value of an investment.

HLOOKUP(lookup_value,table_array,row_index_num,...)

Looks in the top row of an array and returns the value of the

indicated cell.

HOUR(serial_number)

Converts a serial number to an hour.

IF(logical_test,value_if_true,value_if_false)

Specifies a logical test to perform.

INDEX(reference,row_num,column_num)

Uses an index to choose a value from a reference.

INDIRECT(reference,A1)

Returns the reference of a text.

INT(number)

Rounds a number down to the nearest integer.

IRR(value,guess)

Returns the internal rate of return for a series of cash flows.

ISBLANK(value)

Returns TRUE if the value is blank.

ISERR(value)

Returns TRUE if the value is any error except #N/A.

ISERROR(value)

Returns TRUE if the value is any error value.

ISLOGICAL(value)

Returns TRUE if the value is a logical value.

ISNA(value)

Returns TRUE if the value is the #N/A error value.

ISNONTEXT(value)

Returns TRUE if the value is non text.

ISNUMBER(value)

Returns TRUE if the value is a number.

ISTEXT(value)

Returns TRUE if the value is a text.

LEFT(text,num_chars)

Returns the leftmost characters from a text value.

LEN(text)

Returns the number of characters in a text string.

LN(number)

Returns the natural logarithm of a number.

LOG10(number)

Returns the base-10 logarithm of a number.

LOOKUP( )

Returns a value either from a one-row or one-column range,

or from an array.

LOWER(text)

Converts text to lowercase.

MAX(number1,number2,...)

Returns the maximum value in a list of arguments.

MID(text,start_num,num_chars)

Returns a specific number of characters from a text string.

MIN(number1,number2,...)

Returns the minimum value in a list of arguments.

MINUTE(serial_number)

Converts a serial number to a minute.

Sheet