MAX
Gives the largest number in the data specified skipping logical and text values
Syntax of Excel Max formula:
=MAX(number1,[number2], …)
In words:
=Find the max number among(this number, [this number], this number and so on)
Examples of Excel Max formula
=MAX(6,7,76,83,86) will return 86 as it is the largest of all
=MAX(A1:H7) will give the largest number in the range A1:H7