How to use "MAX" Function in Excel

This Function picks the highest value from the given list of values.

Syntax:
=MAX(Range1,Range2,Range3... through to Range30)

Example:

Here is the video tutorial of the same for clear understanding.

Back to MS Excel>>