Thread: Formula <0 leave cell blank
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Formula <0 leave cell blank
if(a1+a2<=0,"",a1+a2)



Whit wrote:

I want A3 to =A1+A2, but how can I make A3 remain blank if it doesn't meet a
certain condition such as 0.

Whit

--

Dave Peterson
Reply With QuoteReply With Quote