CTERM=Calculates the number of compounding periods necessary for an investment to grow to a given future value.~@CTERM(interest, futurevalue, presentvalue)
DDB=Calculates the double-declining balance depreciation allowance of an asset.~@DDB(cost,salvage,life,period)
FV=Calculates the future value of a series of equal payments.~@FV(payments,interest,term)
PMT=Calculates the amount of the periodic payment needed to pay off a loan.~@PMT(principal,interest,term)
PV=Calculates the present value of a series of equal payments.~@PV(payments, interest, term)
RATE=Calculates the periodic interest rate necessary for an investment to grow to a given future value.~@RATE(futurevalue, presentvalue, term)
SLN=Calculates the straight-line depreciation allowance of an asset.~@SLN(cost,salvage,life)
SYD=Calculates the sum-of-the-years'-digits depreciation allowance of an asset.~@SYD(cost,salvage,life,period)
TERM=Calculates the number of payment periods of an investment.~@TERM(payments, interest, futurevalue)
[Mathematical]
ABS=Calculates the absolute (positive) value of a value.~@ABS(x)
ACOS=Calculates the arc cosine of a value.~@ACOS(x)
ASIN=Calculates the arc sine of a value.~@ASIN(x)
ATAN=Calculates the arc tangent of a value.~@ATAN(x)
ATAN2=Calculates the arc tangent of the quotient of two values.~@ATAN2(x,y)
COS=Calculates the cosine of an angle.~@COS(z)
EXP=Calculates the natural logarithm (base e) raised to a specified power.~@EXP(x)
INT=Returns the integer portion of a value.~@INT(x)
LN=Calculates the natural logarithm (base e) of a value.~@LN(x)
LOG=Calculates the common logarithm (base 10) of a value.~@LOG(x)
MOD=Calculates the remainder (modulus) of two values.~@MOD(x,y)
PI=Returns the value of the number pi (approximately 3.1415926536)~@PI
RAND=Generates a random value between 0 and 1~@RAND
ROUND=Rounds a value to a specified number of decimal places.~@ROUND(x,n)
SIN=Calculates the sine of an angle.~@SIN(z)
SQRT=Calculates the positive square root of a value.~@SQRT(x)
TAN=Calculates the tangent of an angle.~@TAN(z)
[Statistical]
AVG=Averages a list of values.~@AVG(list)
COUNT=Counts the nonblank values in a list.~@COUNT(list)
MAX=Finds the greatest value in a list of values.~@MAX(list)
MIN=Finds the least value in list of values.~@MIN(list)
STD=Calculates the standard deviation of the values in a list.~@STD(list)
SUM=Sums the values in a list.~@SUM(list)
VAR=Calculates the population variance of the values in a list.~@VAR(list)
[Logical]
ERR=Returns ERR if the expression is incorrect~@ERR
FALSE=Returns the logical value 0 (false)~@FALSE
IF=Returns one value if the condition is true, and another value if the condition is false.~@IF(condition, x, y)
NA=Returns NA if the expression is not available~@NA
