Adding only positive numbers
Columns A & B
in C1:
=IF(B10,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
"biscuitsmom" wrote:
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?
|