Nokia 9500 User Manual

Page 46

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.

S h e e t