not displaying "FALSE" in cells

V

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.
 
P

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)
 
Top