Hi I recently purchased Numbers in order to create a trading journal. I'm getting away from pen and paper. I need help to create a formula. One column Buy/Sell determines if entry price column is subtracted from exit price column or exit subtracted

Hi B',

Buy/Sell in column B

Entry price in column C

Exit price in column D

Formula (and result) in column E

If column B will always contain either "Buy" or "Sell", this will work. It defaults to a 'sell' calculation if neither Buy or Sell has been specified.

E2: =IF(B="Buy",D-C,C-D)

If you want to delay calculation until amounts have been entered in both C and D, use this version:

E2: =IF(OR(LEN(C)<1,LEN(D)<1),"",IF(B="Buy",D-C,C-D))

If you want to delay calculation until all three ducks are in a row (B contains Buy or Sell, C and D both contain data), use this version:

E2: =IF(OR(LEN(C)<1,LEN(D)<1),"",IF(B="Buy",D-C,IF(B="Sell",C-D,"")))

Third version used in this table.

Regards,

Barry