Forum Discussion

Kevin Peres's avatar
Kevin Peres
Copper Contributor
Sep 04, 2018
Solved

Conditional Formatting return blank if cell blank

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

  • Philip West's avatar
    Philip West
    Iron Contributor

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

    • Kevin Peres's avatar
      Kevin Peres
      Copper Contributor

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

       

      Kevin

       

Resources