Hiding "FALSE" values

  • Thread starter Thread starter Zorro
  • Start date Start date
Z

Zorro

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

TIA
Zorro
 
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.
 
Thanks guys. Just what I needed.

Zorro


J.E. McGimpsey said:
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
Click to expand...
 
Back
Top