Thread: Editing formula results so zeros appear blank
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Editing formula results so zeros appear blank
=if(yourformula=0,"",yourformula)
is pretty common



Holly wrote:

Hi All,

Just wondering if anyone has found a way for a formula result which
calculates to zero to show as a blank cell.
--
Cheers,
Holly

--

Dave Peterson
Reply With QuoteReply With Quote