Formulae:
Result is FALSE. Expected True.=(ROUND(QUARTIL(E62:E70;2);3)=ROUND(E62;3))*AND(ROUND(E62;3))=300
Check:
and=(ROUND(QUARTIL(E62:E70;2);3)=ROUND(E62;3))
The image bel=(ROUND(E62;3))=300
ow contains incorrect operator, should be AND.
Formulae:
Result is FALSE. Expected True.=(ROUND(QUARTIL(E62:E70;2);3)=ROUND(E62;3))*AND(ROUND(E62;3))=300
Check:
and=(ROUND(QUARTIL(E62:E70;2);3)=ROUND(E62;3))
The image bel=(ROUND(E62;3))=300
ow contains incorrect operator, should be AND.
Last edited by vangog; 09-26-2022 at 04:37 AM. Reason: Mistake in formulae
maybe:
=AND(ROUND(QUARTILE(E62:E70;2);3), ROUND(E62;3);300)
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)
Be as you wish to seem
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
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
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.
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.