Menu
In Excel, is there a native function that will return the larger of two values? I'm looking to avoid using the IF function. I'm using Excel 2010 Beta if that's worth anything.
For example: GTR(66,24) will return 66.
798
What is the MAX Function? The MAX Function[1] is categorized under Excel Statistical functions. MAX will return the largest value in a given list of arguments. From a given set of numeric values, it will return the highest value.
We can use the IF Function to check if a cell has a value that is greater than the specified criteria. The IF function returns TRUE if the condition is met and FALSE if otherwise.
Try MAX(Cell1, Cell2). It accepts an unlimited number of parameters.
50
Have a look at Max
The MAX function, one of Excel's statistical functions, is used to find the largest or maximum number in a given list of values or arguments.
=MAX( argument1, argument2, ... argument30 )
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
