Calculates the number of periods for an investment or loan given a fixed rate, period payment, and present value.
NPER
Calculates the future value of an investment given a fixed rate, a term, and identical periodic payments.
FV
Calculates the net present value of an investment with a fixed rate and periodic payments that may be identical or different.
NPV
Calculates cumulative principal for a specified payment period.
CUMPRINC
Calculates the present value of an investment with a fixed rate, specified number of periods, and identical periodic payments that will be made in the future.
PV
Calculates cumulative interest for a specified payment period.
CUMIPMT
A schedule showing monthly payments, interest per payment, amount toward paying off the loan, and the remaining balance for each payment.
Loan Amortization Table
Calculates the principal payment for a specified payment period on a loan or an investment given a fixed rate, a specified term, and identical periodic payments.
PPMT
Calculates periodic interest for a specific payment period on a loan or investment with a fixed rate, a specified term, and identical periodic payments.
IPMT
Returns the average of all cells that meet multiple criteria.
AVERAGEIFS
A type of chart that displays a visual representation of geographic regions to illustrate relative values.
Map Chart
Returns a number representing the day of the week where 1 represents Sunday and 7 represents Saturday by default.
WEEKDAY
Calculates the total of a range of values when a specified condition is met.
SUMIF
A logical function that evaluates multiple conditions and returns a result that corresponds with the first true condition.
IFS
Calculates the fraction of a year between two dates based on the number of whole days.
YEARFRAC
Returns the number of cells that meet a condition.
COUNTIF
Extracts the year from a date.
YEAR
Calculates the total of a range of values when multiple conditions are met.
SUMIFS
Returns TRUE if any argument is true and returns FALSE if all arguments are false.
OR
Returns TRUE when all arguments are true and FALSE when at least one argument is false.
AND