hide the returned value "false" I have submerged zero values

M

Ms Trish

Although I have submerged zero values, and hidden formulas, the cell still
displays "false" when the if statement has not been met. How can I have the
word "false" submerged.
 
B

Biff

Hi!

Use a return of zero in your IF function when the logical test is FALSE.

An alternative, use conditional formatting to hide them.

Conditional Formatting:
Cell value is: equal to: FALSE
Set the font color to be the same as the background color

Biff
 
P

Peo Sjoblom

=IF(A1=X,200,"")

meaning if the condition is not met return blank

adapt to fit

--
Regards,

Peo Sjoblom

(No private emails please)
 
Top