Hiding "FALSE" values

[Zorro]

I know how to hide zero values, but can anyone tell me how to "FALSE"
values.

TIA
Zorro

 

[Bob Phillips]

Trap the condition that creates it. For instance, in the formula
=IF(A1=17,"Yes") will return Yes if A1 is 17, but FALSE otherwise. SO if you
use
=IF(A1=17,"Yes","")
you don't get FALSe.

Similarly with other formulae.

 

[Zorro]

Thanks guys. Just what I needed.

Zorro

Just a couple more ways. If you want to retain the FALSE values, you
can choose Format/Conditional Formatting... and enter

Cell Value is equal to FALSE,

click on Format, then choose the same font color as the background
color.

If you have an IF(x, y) or IF(x, y, FALSE) constructions, where y is
numeric, you can also use the format

Format/Cells/Number/Custom 0;0;0;

to hide FALSE