View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ASG ASG is offline
external usenet poster
 
Posts: 2
Default If formula result = 0, do not display-leave cell blank

Thank you Pete that solved my problem

"ASG" wrote:

When the result of a formula's calculation is zero (0) I want the cell to
remain blank instead of showing 0. I am using Microsoft office Excel 2007