I need the FALSE result to be blank

[tlwarranties]

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

[#2 · Accepted solution]

@tlwarranties 

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

You can try this formula.

 

[#3]

perfect, thank you!

[#4]

@tlwarranties 

You are welcome.