Forum Discussion
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
like this? =IF(ISBLANK(J13),"",IF(SMALL(F13:G13,1)>=J13,"Pass","Fail"))
2 Replies
- Philip WestIron Contributor
like this? =IF(ISBLANK(J13),"",IF(SMALL(F13:G13,1)>=J13,"Pass","Fail"))
- Kevin PeresCopper Contributor
That is perfect thank you very much. I was so close with one of my formula's Thank you for the education.
Kevin