View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 620
Default not displaying "FALSE" in cells

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.