The IF function in Google Sheets is the next logical step up from the basic functions such as the SUM or AVERAGE functions.

As the name suggests, MAX and MIN functions will find the maximum and minimum values in a numerical dataset, but they can do so much more!

The average function gives us a number representing the central or typical value. But how does an average formula actually work?

The most fundamental function is arguably the SUM function, we'll break this down and show you some cool shortcuts.