Subtracting negative and positive numbers using multiple conditions in an Excel formula

[Deeweb1]

Hi,

I am evaluation a spreadsheet and need create a formula that will evaluate 4 different scenarios...

First based on if a text of 2 cells are Favorable or Unfavorable, then add or subtract based on the cell text.

So.. this is what I am trying to achieve in 1 formula

If D5="Favorable" and L5="Favorable", then add D6+L6
If D5="Unfavorable" and L5="Unfavorable", then add D6+L6
If D5="Favorable" and L5="Unfavorable", then subtract D6-L6
If D5="Unfavorable" and L5="Favorable, then subtract L6-D6

Thank you so much for your help

 

[Michael M]

UNTESTED.....and willl show blank if either cell is blank

=IF(OR(D5="",L5=""),"",IF(AND(D5="Favorable",L5="Favorable"),D6+L6,IF(AND(D5="Unfavorable",L5="Unfavorable"),D6+L6,D6-L6)))