(7) How to use MAX formula in Microsoft Excel.
MAX: MAX Function returns the largest value in a set of values.
=MAX(RANGE)
Example:
Give the formula in B11 cell.
| Formula |
Description |
Result |
| =MAX(B2:B10) |
Returns the largest value in a set of values.
here, RANGE=B2:B10. You can use any range as per your requirement. |
95
|
=MAX(B2,B3,B4,B5,B6,B7,B8,B9,B10) |
Returns the largest value in a set of values.
|
95
|
| =MAX(85,80,80,85,95,85,80,80,85) |
Returns the largest value in a set of values. |
95 |
Video:
How to use MAX formula in Microsoft Excel:
|