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
Created by Linda (tutor)
about 4 years ago

