0

I need to add the product of one cell to another cell, but only if the second cell is a negative number. The product of the first cell is a result of another formula and is always positive. The product of the second cell may be either positive or negative but only added if a negative number is produced?

Improve this question
5
  • what do you want to return if it is not negative?
    – Scott Craner
    Apr 4, 2019 at 18:51
  • Do you want to use if?
    – Leonardo Alves Machado
    Apr 4, 2019 at 18:52
  • A blank cell, if possible.
    – David
    Apr 4, 2019 at 18:59
  • See edited answer below
    – Scott Craner
    Apr 4, 2019 at 19:14
  • You need IF function!
    – Lee
    Apr 5, 2019 at 6:38

1 Answer 1

Reset to default
1

Use a standard IF()

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

Where A1 contains the product of your first formula and B1 the product of the second.

Improve this answer
1
  • Some versions of Excel uses ";" instead of "," as the separator (like my swedish version).
    – Ola Ström
    Apr 4, 2019 at 19:16

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .