MAX Function

  • Thread starter Thread starter angy345
  • Start date Start date
A

angy345

Hi, i have a function in Excel as below:

=MAX(B2:B6) - MIN(B2:B6)

For example if the maximum value is 11 and the minimum is 0, the result
is 0 when the function is excuted in Excel. Is that correct ?? or
should the answer be 11. Because from a logical point of view 11 minus
0 equals to 11.

All replies are welcome
Many thanks
 
Hi

The answer is 11!

The only way to get your result, I can imagine of, is when all entries'
except the one equal to 0, are not numbers but texts (cells are formatted as
text, or values are preceeded with apostrophe, or they were formatted as
text before, and formulas weren't recalculated after reformatting). To check
this, remove any alicnments from cell(s) - when entries are then
left-aligned, then they are texts, when right-aligned, then they are
numbers.
 
Ooops ! i made an error..Sorry....in the range MAX(B2:B6) the onl
number that i have is 11 and i want to execute :
=MAX(B2:B6) - MIN(B2:B6)
And the answer i get it Zero. Is that good
 
Back
Top