maxa function results in value error in worksheet

[cs]

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

 

[Bernard Liengme]

I am not sure what you mean by: number 1 b17:d17+f7 ={173,176,208}

What is the formula you are using?
What is the result of the formula?
What values are displayed in the cells referenced by the formula?
best wishes

 

[Shane Devenshire]

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(B1717,F17)

is probably correct.