View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vinnie123 vinnie123 is offline
external usenet poster
 
Posts: 6
Default not displaying "FALSE" in cells

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.