not displaying "FALSE" in cells

[vinnie123]

I'm sure it is a really straightforward problem.

I have a sheet with a lot of data generated form formulas, mainly
VLOOKUP and IF with output being whole numbers. How can I stop the word

"FALSE" from appearing in cells with no valid data, just leaving those

cells blank.


Regards, Vinnie.

 

[Peo Sjoblom]

Post your formula would be the easiest way,
An IF function will for instance return FALSE if a condition is not TRUE so

=IF(A1>2,"Yabadabadoo")

will return FALSE if it is not greater than 2, to return a "blank" you would
change the formula to


=IF(A1>2,"Yabadabadoo","")


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)

 

[David Biddulph]

Please don't multipost.
Cross-post, if you must:
http://www.cs.tut.fi/~jkorpela/usenet/xpost.html