Thread: Hiding the value of a formula if 1 cell has a value of zero.
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Bondi
 
Posts: n/a
Default Hiding the value of a formula if 1 cell has a value of zero.
Hi,
In A3,

=IF(A1=0,"",A1+A2)

Regards,
Bondi

Reply With QuoteReply With Quote