SOLVED

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)
Solution

@tlwarranties 

=IF(A1<500,500,"")

You can try this formula.

show false as blank.JPG 

perfect, thank you!

@tlwarranties 

You are welcome.