Adding only positive numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Numbers showing Up Centered in Cell ? 1
Excel - Adding positive or negative numbers in a column 5
How to determine the value within specific cell position? 5
How to determine the ranking positions? 3
Complex Match 3
Help with positive and negative numbers 1
Macro to add numbers in a text string 5
Excel Help to copy information from one row at a time to another sheet 1

Back
Top