Add two cells if one cell is greater than 0
 

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

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

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