I need the FALSE result to be blank

Occasional Contributor

I have a formula in cell B1: =IF(A1<500, 500) but if A1 is greater than 500, B1 shows FALSE and I need that cell to be blank in that case

3 Replies
best response confirmed by tlwarranties (Occasional Contributor)



You can try this formula.

show false as blank.JPG 

perfect, thank you!


You are welcome.