SOLVED

Conditional Formatting return blank if cell blank

Copper Contributor

Hello, Thank you for taking the time to read this post.

 

I have 2 If formulas that I am having a heck of a time with.

 

What I want is for the cell to be blank if the <= or <= is blank.  As it is now I will get a Pass or a Fail even if the referenced cell is blank.

Here are the two formulas.

=IF(LARGE(C13:D13,1)<=I13,"Pass","Fail")

=IF(SMALL(F13:G13,1)>=J13,"Pass","Fail")

 

I have read many solutions that are similar but I just cannot figure out the syntax.  

 I would appreciate any assistance.

 

regards,

kevin

 

 

2 Replies
best response confirmed by Kevin Peres (Copper Contributor)
Solution

like this? =IF(ISBLANK(J13),"",IF(SMALL(F13:G13,1)>=J13,"Pass","Fail"))

That is perfect thank you very much.  I was so close with one of my formula's  Thank you for the education.

 

Kevin

 

1 best response

Accepted Solutions
best response confirmed by Kevin Peres (Copper Contributor)
Solution

like this? =IF(ISBLANK(J13),"",IF(SMALL(F13:G13,1)>=J13,"Pass","Fail"))

View solution in original post