Adding only positive numbers

B

biscuitsmom

I have 2 columns of numbers. I want to add column 2 to column 1 but only if
the number in column 2 is a positive number. How do I do this?
 
T

Toppers

Columns A & B

in C1:

=IF(B1>0,A1+B1,"")

If B <= 0, result is blank.

Is this what you want?

If you want answer in column A, then you will need VBA.

HTH
 
Top