S h e e t

MOD(number,divisor)

Returns the remainder from division.

MONTH(serial_number)

Converts a serial number to a month.

N(value)

Returns a value converted to a number.

NOW( )

Returns the serial number of current date and time.

NPV(rate,value1,value2,...)

Returns the net present value of an investment based on a

series of periodic cash flows and a discount rate.

OFFSET(refernce,rows,cols,height,width)

Returns a reference to a range that is a specified number of

rows and columns from a cell or range of cells.

PERMUT(number, number_chosen)

Returns the number of permutations for a given number of

items.

PI( )

Returns the value of pi.

PMT(0,0,0)

Returns the periodic payment for an annuity.

POWER(number,power)

Returns the result of a number raised to a power.

PRODUCT(number1,number2,..)

Multiplies its arguments.

PROPER(text)

Capitalises the first letter in each word of a text value.

PV(rate,nper,pmt,fv,type)

Returns the present value of an investment.

RADIANS(angle)

Converts degrees to radians.

RAND( )

Returns a random number between 0 and 1.

RATE(nper,pmt,pv,fv,type,guess)

Returns the interest rate period of an annuity.

REPLACE(old_text,start_num,num_chars,new_text)

Replaces characters within text.

REPT(text,number_times)

Repeats text a given number of times.

RIGHT(text,num_chars)

Returns the last character or characters from a text value.

ROUND(number,num_digits)

Rounds a number to a specified number of digits.

ROW(row)

Returns the row number of the specified row.

ROWS(array)

Returns the number of rows in a reference.

SECOND(serial_number)

Converts a serial number to a second.

SIGN(number)

Returns the character for the number.

SIN(number)

Returns the sine of the given angle.

SLN(cost,salvage,life)

Returns the straight line depreciation of an asset for one

period.

SQRT(number)

Returns a positive square root.

STDEV(number1,number2,...)

Estimates standard deviation based on a sample.

STDEVP(number1,number2,...)

Calculates standard deviation based on the entire population.

STRING( )

Converts a number to text according to the given format string.

SUM(number1,number2,...)

Adds its arguments.

SUMPRODUCT(array1,array2, )

Returns the sum of the multiplied arrays.

SUMSQ(array1,array2)

Returns the sum of the squares.

SYD(cost, salvage, life, per)

Returns the sum of years' digits depreciation of an asset for a

specific period.

T(value)

Converts its arguments to text.

TAN(number)

Returns the tangent of a number.

TERM( )

Calculates the number of payments for an investment, given

the periodic payment amount P, the interest rate R, and future

value FV.

Copyright   2005 Nokia. All Rights Reserved.

49