Thread: Add two cells if one cell is greater than 0
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Add two cells if one cell is greater than 0
Try,

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

Mike

"qh8519a" wrote:

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