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.