# MAXA

MAXA(value1 [,value2] [..])

Returns the largest value in a list or array of numbers (including logical values and text).

 value1 The first value. value2 (Optional) The second value.

 REMARKS
 * This is identical to the MAX function except that logical values and text are included.* This function includes hidden cells.* Arguments that are numbers are included.* Arguments that are zero are included.* Arguments that are dates are included.* Arguments that evaluate to True are included and 1 is used.* Arguments that evaluate to False are included and 0 is used.* Arguments that are text are included and 0 is used.* 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 MAX function to return the largest value in a list or array of numbers.* You can use the MAXIFS function to satisfy multiple conditions.* You can use the MAXAVISIBLE - User Defined Function to exclude hidden cells.* This is similar to the AVERAGEA function.* This is similar to the COUNTA function.* This is similar to the MINA function.* For the Microsoft documentation refer to support.microsoft.com

 A 1 =MAXA(5,2,6,9) = 9 2 =MAXA(2,4,6,8) = 8 3 =MAXA({5,4,3,2,1}) = 5 4 =MAXA(4,3,TRUE,5,"4",9,3) = 9 5 =MAXA("","") = #VALUE!