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

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

value1The 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 rows.
* 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 MAXIF - User Defined Function if you want to satisfy one condition.
* You can use the MAXIFS function to satisfy multiple conditions.
* 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.office.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!


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top