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.

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

=IF(A12,"Yabadabadoo")

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


=IF(A12,"Yabadabadoo","")


--


Regards,

Peo Sjoblom

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


"vinnie123" wrote in message
ups.com...
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.

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

"vinnie123" wrote in message
ups.com...
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.