MAX Function

[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

 

[Arvi Laanemets]

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.

 

[angy345]

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

 

[Frank Kabel]

Thats good As in this case MAX in MIN both evaluate to 11. And 11 -
11 = 0

Frank

 

[angy345]

Yes Frank, you are right !! i haven't thought about that. it's clear
now.

thanks a lot.

 

[Frank Kabel]

you're welcome
Frank