Functions and Formulae Level 2

Function to return a value dependent on specific criteria

BODMAS

Function used to calculate the AVERAGE value of a range of cells

Function used to calculate the MAXIMUM value in a range of cells

Function used to calculate the MINIMUM value in a range of cells

Function used to calculate the SUM (total) of a range of cells

Function used to
COUNT a range of cells which contain NUMERIC data

Function used to
ROUND the value in a range of cells to a set number of decimal places (e.g. 0, 1, 2)

Function used to
COUNT a range of cells which contain data

Function used to
COUNT a range of cells which do not contain data

Formula to MULTIPLY cells

Formula to SUBTRACT data in cells

Formula to DIVIDE numeric data in cells

Formula to ADD numeric data together