Excel Functions

Excel functions cheatsheet - sum, min, max, roundup, if, rounddown, sumif, vlookup, hlookup, countif, index, match and more

Rounds down a single number to the nearest specified value, usually to a whole number.

Looks up a range and returns the first corresponding value in a vertical table that matches exactly the specified input.

Looks up a range and returns the first corresponding value in a horizontal table that matches exactly the specified input. An error is returned if it cannot find the exact match.

Works like the coordinates of a map and returns a single value based on the column and row numbers you input into the function fields.