An Excel's Max Formula is used to get the highest or largest number/amount from the range of data.
Syntax:
- Write =Max(
- Select the cell range of data containing table
- complete ) and enter
#Excel max formula with examples:
- Max function accepts up to 255 arguments.
- If there is no any number in range, it return 0.
The max formula also can be used to get the largest or to find the latest date. Let's see an example here:
The example show how to get the last update date when stock was updated by the person with the usage of Max function:
And the answer is:
You may find and learn more Excel Formulas here: