Menu
EXCEL MAX FUNCTION
Excel MAX Function Introduction
This method returns the biggest number from a cell range while excluding logical values and text.
Description of Excel MAX Function
Syntax:
= MAX(number1, [number2], …)
Parameter list:
- number1 – the number or numbers in the cell range.
- number2 – [optional You have a range of 1 to 255 integers for which you want to determine the maximum value.
Step By Step Guide of MAX Function
In this Example, we are looking for the greatest value in the B column and the highest date in the C column.
Key Points
- Arguments can be integers, words, arrays, or references containing numbers.
- Logical values and text representations of integers entered directly into the argument list are recorded.
- When an argument is an array or a reference, just the integers in that array or reference are utilised.
- Blank cells, logical values, or words in the array or reference are discarded.
- If the inputs do not include any numbers, MAX returns 0. (zero).
- Errors are caused by arguments that are error values or language that cannot be converted into numbers.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
