User's Manual

Table Of Contents

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.

MOD(number,divisor) Returns the remainder from division.

MONTH(serial_number) Converts a serial number to a month.

Sheet