Forum Discussion
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 i...
like this? =IF(ISBLANK(J13),"",IF(SMALL(F13:G13,1)>=J13,"Pass","Fail"))
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