Hello,

Having difficulties to get my furmula working, I have the following:

=IF((U5<L3; "PASS";IF(U5=0;"";IF(U5<1;"";"FAIL")) )

If U5 is higher than the valua in L3 it needs to return "PASS", if it is 0 it needs to remain Blanc, if the value is anywehere between 1 and 10 it needs to return "FAIL"

Hope you can help me.

Thank you!