View Single Post
  #1   Report Post  
jake
 
Posts: n/a
Default 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