View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
external usenet poster
 
Posts: 427
Default Returning nothing if formula is false

One way to do this is to change the formulas to include IF formulas,
like this:
IF(your original formula=0,"",your original formula)
This will return an empty cell if the original formula yields a zero.