Thread: Add two cells if one cell is greater than 0
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
  
Posts: 2,480
Default Add two cells if one cell is greater than 0
Hi Drew

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

--
Regards
Roger Govier

"qh8519a" wrote in message
...
I am looking to add cells 'a' and 'b' if cell 'a' is greater than '0'. If
cell 'a' is less than or equal to '0', I would like the value to be 0.
Any
help would be appreciated.

Thanks
Drew

Reply With QuoteReply With Quote