Instructing a cell when to add/substract with a word

[dyno718]

I am trying to create a cell (C1) that if I say its BUY then it will add cell A1 and B1 into D1 and if C1 says SELL then it will subtract cell A1 and B1 and but the total in D1, how do I do this? Thanks for your help!

 

[Rick Rothstein]

Give this formula in a try (in D1)...

=IF(C1="BUY",A1+B1,IF(C1="SELL",A1-B1,""))

Note that I might have the subtraction A1-B1 backward... if you get a negative value, then perhaps it should be B1-A1... just something for you to be alert about.

 

[dyno718]

Worked like a charm thank you so much!