Nokia 9500 manual COUNTAvalue1,value2

S h e e t
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.

Copyright © 2004 Nokia. All Rights Reserved. 46