Formula with OR condition does not return expected result

[vangog]

Formulae:


=(ROUND(QUARTIL(E62:E70;2);3)=ROUND(E62;3))*AND(ROUND(E62;3))=300

Result is FALSE. Expected True.

Check:

=(ROUND(QUARTIL(E62:E70;2);3)=ROUND(E62;3))
and

=(ROUND(E62;3))=300

The image bel
ow contains incorrect operator, should be AND.

[arnelgp]

maybe:

=AND(ROUND(QUARTILE(E62:E70;2);3), ROUND(E62;3);300)

[Aflatoon]

If you actually wanted OR, it's in the wrong place:

=OR(ROUND(QUARTIL(E62:E70;2);3)=ROUND(E62;3);ROUND(E62;3)=300)

[Aussiebear]

I've taken the time to breakdown your function into mini tests

"=Quartile(E62:E70,2)" returns 300
"=Round(Quartile(E62:E70,2),3)" returns 300
"=Round(E62,3)" returns 300
"=Or(Round(E62,3)" returns True
"=Round(E62,3)*Or(Round(E62,3)" returns 300
"=Round(Quartile(E62:E70,2),3)=Round(E62,3)*Or(Round(E62,3))" returns 300

So I can't find any fault on this Mac

[snb]

The quartile of a range that encompasses E62 can only be equal to E62 if the range doesn't contain any values at all, other than the value in E62.
To test for blank cells in a range a simpler method in Excel is available.

[vangog]

Sorry. When I have translated from my local language, I changed AND function to OR. But thank you, now it is clear to me how OR/AND works in Excel.