List of @functions A-Z
@AVG(list) calculates the average of the values in list.

@DATE(year;month;day) calculates the date number for the specified year, month, and day.

@DAY(date-number) extracts the day of the month, a value from 1 through 31, from date-number.

@ERR returns the value ERR.

@FV(payments;interest;term) calculates the future value of an investment, based on a series of equal payments, earning a periodic interest rate, over the number of payment periods in term, assuming an ordinary annuity.

@IF(condition;x;y) evaluates condition and returns either x if condition is true or y if condition is false.

@INFO(attribute) returns information about the current eSuite spreadsheet work session.

@IRR(guess;range) calculates the internal rate of return (profit) for a series of cash-flow values generated by an investment.

@MONTH(date-number) extracts the month, a value from 1 through 12, from date-number.

@NA returns the value NA (not available).

@NPV(interest;range;[type]) calculates the net present value of a series of future cash-flow values (range), discounted at a fixed periodic interest rate.

@PAYMT(principal;interest;term;[type];[future-value]) calculates the payment on a loan (principal) at a given interest rate for a specified number of payment periods (term). @PAYMT calculates for either an ordinary annuity or an annuity due, depending on the value you specify for type.

@PMT (principal;interest;term) calculates the payment on a loan (principal) at a given interest rate for a specified number of payment periods (term), assuming an ordinary annuity.

@PV(payments;interest;term) calculates the present value of an investment, based on a series of equal payments, discounted at a periodic interest rate over the periods in term, assuming an ordinary annuity.

@ROUND(x;n) rounds the value x to the nearest multiple of the power of 10 specified by n.

@SUM(list) adds the values in list .

@SYD(cost;salvage;life;period) calculates the sum-of-the-years'-digits depreciation allowance of an asset for a specified period.

@TERM(payments;interest;future-value) calculates the number of periods required for a series of equal payments to accumulate a future-value at a periodic interest rate, assuming an ordinary annuity.

@TODAY calculates the date number that corresponds to the current date on your computer.

@YEAR(date-number;[type]) extracts the year, an integer from 0 (1900) through 8099 (9999), from date-number.

@YIELD(settlement;maturity;coupon;price;[redemption];[frequency];[basis]) returns the yield for securities that pay periodic interest.