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.