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 |
| 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 |
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 |
LOOKUP( ) | Returns a value either from a |
| 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 |