why doesn't my conditional formula work?
can anyone tell me why the following doesn't work?
=IF(B3="Buy", [G3*(F3-E3)], [G3*(E3-F3)])
or possibly suggest another way of achieving the same result, so that a
'Buy' transaction will produce one calculation, and a 'Sell' (or non-'Buy)
transaction will produce another?
cheers
|