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?

  • what do you want to return if it is not negative? – Scott Craner Apr 4 '19 at 18:51
  • Do you want to use if? – Leonardo Alves Machado Apr 4 '19 at 18:52
  • A blank cell, if possible. – David Apr 4 '19 at 18:59
  • See edited answer below – Scott Craner Apr 4 '19 at 19:14
  • You need IF function! – Lee Apr 5 '19 at 6:38
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|||||
  • Some versions of Excel uses ";" instead of "," as the separator (like my swedish version). – Ola Ström Apr 4 '19 at 19:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.