A Simple Question, please help.

[greeny1007]

Hi,

Im not an excel whizz at all, but I'm pretty sure what I want to do is quite straightforward.

I have a drop down box that gives only two options.
I want another cell to perform one of two calculations, depending on what is selected in the drop down box.
The calculations are very simple, the first adds cell A to cell B, the second detracts cell A from cell B.

For example:

If the drop down box in cell B5 is showing 'BUY', I want cell E5 to display =SUM(C5-D5)
If the drop down box in cell B5 is showing 'SELL', I want cell E5 to display =SUM(D5-C5)

That's it. I think it might have something to do with IF? or SUMIF? I don't know, please help me, I know this must be a no-brainer for someone well versed in excel.

Thanks in advance.

[JieJenn]

You don't need Sum just an FYI

=IF(B5="Buy",C5-D5,IF(B5="Sell",D5-C5,""))

[greeny1007]

Awesome, Thanks so much , I knew it would be something simple like that.

[teylyn]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST