47 functions to practice

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

• ANDAND returns TRUE only when every condition is TRUE. 1 exercise.
• AVERAGEAVERAGE returns the arithmetic mean of its arguments, ignoring empty cells and text. 2 exercises.
• AVERAGEIFAVERAGEIF averages the cells in a range that meet one condition. 1 exercise.
• COUNTCOUNT counts the cells that contain numbers. 1 exercise.
• COUNTACOUNTA counts the cells that are not empty, whatever they contain. 1 exercise.
• COUNTIFCOUNTIF counts the cells in a range that meet one condition. 3 exercises.
• COUNTIFSCOUNTIFS counts the rows that meet several conditions at once. 1 exercise.
• DATEVALUEDATEVALUE converts a date written as text into a real date serial number. 1 exercise.
• EDATEEDATE returns the date a given number of months before or after a start date. 1 exercise.
• EOMONTHEOMONTH returns the last day of the month a given number of months away. 1 exercise.
• FINDFIND returns the position of one text string inside another, case-sensitive. 1 exercise.
• FVFV returns the future value of an investment with regular payments and a constant rate. 1 exercise.
• IFIF returns one value when a condition is TRUE and another when it is FALSE. 5 exercises.
• IFERRORIFERROR returns a replacement value when a formula produces an error. 1 exercise.
• IFSIFS checks several conditions in order and returns the value for the first one that is TRUE. 1 exercise.
• INDEXINDEX returns the value at a given row and column position in a range. 2 exercises.
• IRRIRR returns the internal rate of return of a series of cash flows at regular intervals. 1 exercise.
• LARGELARGE returns the nth largest value in a range. 1 exercise.
• LEFTLEFT returns the first characters of a text. 1 exercise.
• LENLEN returns the number of characters in a text. 1 exercise.
• LOWERLOWER converts text to lower case. 1 exercise.
• MATCHMATCH returns the position of a value in a range. 3 exercises.
• MAXMAX returns the largest value in its arguments. 1 exercise.
• MAXIFSMAXIFS returns the largest value among the cells that meet one or more conditions. 1 exercise.
• MEDIANMEDIAN returns the middle value of a set of numbers. 1 exercise.
• MIDMID returns a given number of characters from the middle of a text, starting at a position. 1 exercise.
• MINMIN returns the smallest value in its arguments. 1 exercise.
• MONTHMONTH returns the month of a date as a number from 1 to 12. 1 exercise.
• NPVNPV returns the net present value of a series of future cash flows at a discount rate. 1 exercise.
• OROR returns TRUE when at least one condition is TRUE. 1 exercise.
• PMTPMT returns the periodic payment for a loan with a constant rate. 3 exercises.
• PROPERPROPER capitalizes the first letter of each word in a text. 3 exercises.
• PVPV returns the present value of a series of future payments at a constant rate. 1 exercise.
• ROUNDROUND rounds a number to a given number of decimal places. 1 exercise.
• ROUNDUPROUNDUP rounds a number away from zero to a given number of places. 2 exercises.
• SLNSLN returns the straight-line depreciation of an asset for one period. 1 exercise.
• SUBSTITUTESUBSTITUTE replaces every occurrence of one text with another. 1 exercise.
• SUMSUM adds its arguments, ignoring text and empty cells. 4 exercises.
• SUMIFSUMIF adds the cells in a range that meet one condition. 3 exercises.
• SUMIFSSUMIFS adds the cells that meet several conditions at once. 1 exercise.
• SUMPRODUCTSUMPRODUCT multiplies matching values in two or more ranges and adds the results. 1 exercise.
• TEXTJOINTEXTJOIN joins several texts with a delimiter, optionally skipping empty cells. 1 exercise.
• TRIMTRIM removes leading, trailing and repeated spaces from a text. 4 exercises.
• VALUEVALUE converts a number stored as text into a real number. 1 exercise.
• VLOOKUPVLOOKUP searches the first column of a range and returns a value from another column in the same row. 5 exercises.
• XLOOKUPXLOOKUP searches a range and returns the matching item from another range, with a built-in result for a missing value. 2 exercises.
• YEARYEAR returns the year of a date as a number. 1 exercise.