Adding positive amount, but ignoring negative

[Guest]

I would like to write a formula in column C that if column B’s amount is
positive, to add it to the amount in Column A, but if the amount in column B
is negative, to simply add zero to the amount in Column A.

 

[Tom Ogilvy]

=if(B1>0,A1+B1,A1)

drag fill down the column.

 

[Guest]

How about

In C1 put the formula =if(B1>0,A1+B1,A1)

Joe V.

 

[Guest]

Thanks Guys!