IF/AND statement for two values

[flaren]

Good day,

I have a formula that determines if a value is a "pass" or "fail", based two other values. The following is what I have;

=IF((AND(C2>=E2, C2<=F2)), "Pass", "Fail")

It works great, however, my question is how to leave the cell blank if there is no value inputted into the cell.

Thank you in advance.

 

[Marcílio_Lobão]

flaren, Good evening.

Try to use:

=IF(OR(C2="", E2="", F2=""), "", IF(AND(C2>=E2, C2<=F2), "Pass", "Fail"))

Is that what you want?
I hope it helps.

 

[flaren]

That work's great... Thank you very much for your help!!

 

[Marcílio_Lobão]

flaren, Good afternoon.

Glad to have helped you.

have a nice day!