MAX |
MAX(number1 [,number2] [..]) |
Returns the largest value in a list or array of numbers. |
number1 | The first number. |
number2 | (Optional) The second number. |
REMARKS |
* This function includes hidden cells. * Arguments that are numbers are included. * Arguments that are dates are included. * Arguments that are zero are included. * Arguments that are logical values are excluded. * Arguments that are text are excluded. * If any cell references are empty, then these are excluded. * If any cell references contain an error, then that error is returned. * You can have a maximum of 255 arguments. * You can use the MAXA function to include logical values and text. * You can use the MAXIFS function to satisfy multiple conditions. * You can use the MAXVISIBLE - User Defined Function to exclude hidden cells. * You can use the MAXIFSVISIBLE - User Defined Function to exclude hidden cells. * You can use the AGGREGATE function to exclude hidden cells. * This is similar to the AVERAGE function. * This is similar to the MIN function. * For the Microsoft documentation refer to support.microsoft.com |
|
© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top