Thread: Simple One
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
  
Posts: 4,339
Default Simple One

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

"Wanna Learn" wrote:

Hello I want to add column A and column B, but if the total is zero I do
not want the zero to show, I tried =if(a2+a3=0), " ",)a2+a2) .. but it is
obviously wrong thanks
Reply With QuoteReply With Quote