Hi,

The max of all those numbers should be 301? And maybe its even worse
because you show b17:d17+f7 which means you are adding F7 to B17, C17, D17??

MAXA is only used if you have text or logical entries in the range.

However, your problem arises from the use of references like b17:d17

=MAXA(B17:D17,F17)

is probably correct.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"cs" wrote:

using maxa function shows correct result but results in a value error in
worksheet. i checked to make sure the numbers were not formatted as text.

number 1 b17:d17+f7 ={173,176,208}
number 2 b27:d27+f17 ={186,191,301]
number 3 b37:d37 +F27 ={172,153,196)

formula result = 208

worksheet shows value error