Learn how to calculate Average, Minimum and Maximum in Excel. We show you how to use MIN, Max, and AVERAGE Functions in Excel.

There's a lot going on in these formulaic conditional rules in Microsoft Excel that highlight the smallest and largest values within a period of years.

You probably know how to use the MAX () and MIN () functions, to return the latest and earliest dates, respectively, in a range. But, how would you grab a corresponding value for that date?

Create an expression for and use optimisation to find the greatest/least value(s) a function can take as well as the rate of change in Higher Maths.