Ignore empty columns, if checking values IF(And..

Hi Dears,
created an analysis sheet checking if values are within a certain range.
Problem is: Some values are not specified, therewith empty...

Example:
Is value (C) above minimum (A) and below maximum (B), please return with yes otherwise no.
Formula used: =IF(AND(C2>=A2;C2<=B2);"YES";"NO")
Works perfectly, as log (A) and (B) carry values!
If I have specified only minimum (A) and maximum (B) is empty (or other way round), this formula returns “NO”.
It should be “YES” as “C” is higher than “A” and who cares about B, it is empty.
Well I tried several but cant find the key.

Please HELP!
Thank you so much

ok, so if both A and B are populated you want
=IF(AND(C2>=A2;C2<=B2);"YES";"NO")

But if Only A is populated, and b is blank you want
=IF(C2>=A2;"YES";"NO")

But if Only B is populated, and A is blank you want
=IF(C2<=B2;"YES";"NO")


Is that about right?

Originally Posted by AliGW

=if(or(c2>=a2;c2<=b2);"yes";"no")

Not quite, if A2 is blank, then C2>=A2 is TRUE, so OR would be true regardless if C2<=B2
And if both are populated, it will ALWAYS be TRUE regardless of C value, given that B is > A

Or try this
=IF(AND(C2>=A2,C2<=IF(B2="",C2,B2)),"YES","NO")

Or try this
=IF(AND(C2>=A2,C2<=IF(B2="",C2,B2)),"YES","NO")

IT WORKS!
Thank you! Took a while until I understood, but have added the command for IF A="" as well and jupidu here we go!
FANTASTIC! GREAT ! THANK YOU so much.