Excel =Max not working??

Why does my =Max formula E: =MAX(M2:N2) only keep showing the N2 number regardless if it is higher or lower than M2?


|
Answer
Answer

It sounds like the M2 value is numeric-text...not a number.

Try this in a blank cell:

=ISNUMBER(M2)

 

If the result is FALSE

...check the contents of M2 for leading/trailing spaces

...Check if M2 has a number format of "Text"

 

Let us know what you find

Regards,

Ron Coderre
Former Microsoft MVP - Excel

21 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated May 27, 2021 Views 15,094 Applies to: