19 functions to practice

Each function page explains what the function does, shows its syntax, and lists the exercises on Modeldrill that use it.

• ANDAND returns TRUE only when every condition is TRUE. 1 exercise.
• CHOOSECHOOSE returns one value from a list by its position number. 1 exercise.
• COUNTIFCOUNTIF counts the cells in a range that meet one condition. 2 exercises.
• IFIF returns one value when a condition is TRUE and another when it is FALSE. 3 exercises.
• INDEXINDEX returns the value at a given row and column position in a range. 2 exercises.
• IPMTIPMT returns the interest part of one loan payment. 1 exercise.
• IRRIRR returns the internal rate of return of a series of cash flows at regular intervals. 1 exercise.
• MATCHMATCH returns the position of a value in a range. 1 exercise.
• MAXMAX returns the largest value in its arguments. 5 exercises.
• MINMIN returns the smallest value in its arguments. 1 exercise.
• NPVNPV returns the net present value of a series of future cash flows at a discount rate. 2 exercises.
• PMTPMT returns the periodic payment for a loan with a constant rate. 2 exercises.
• PPMTPPMT returns the principal part of one loan payment. 1 exercise.
• ROUNDUPROUNDUP rounds a number away from zero to a given number of places. 1 exercise.
• SUMSUM adds its arguments, ignoring text and empty cells. 10 exercises.
• SUMIFSUMIF adds the cells in a range that meet one condition. 1 exercise.
• SUMPRODUCTSUMPRODUCT multiplies matching values in two or more ranges and adds the results. 1 exercise.
• XIRRXIRR returns the internal rate of return of cash flows on specific dates. 2 exercises.
• XNPVXNPV returns the net present value of cash flows on specific dates. 1 exercise.