If statement - return blank

[Alphazulu]

I am using the following formula to indicate pass or fale in cell D4 if C4 is greater or equal to 1.

=IF(C4<=1, "Pass","Fail")

I'd like to update the formula to leace Cell D4 blank if no value is entered in C4. Currently the result is Pass.

Any ideas?

 

[Jonmo1]

Try

=IF(C4="","",IF(C4<=1,"Pass","Fail"))

 

[Trouttrap2]

adding another if statement will do it;

=IF(C4="","",IF(C4<=1,"Pass","Fail"))