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
Copyright © 2005 Nokia. All Rights Reserved. 49