Forum Discussion
formula creation
Hi, I am trying to create a formula for my share trading spreadsheet (I just added a comment in here but I think I deleted it somehow :-( If I trade 1 contract the commission paid is $4.25, if I tra...
HI Anthony
Lets assume the number of trades is in cell A1 then your formula is
=IF(A1=0,0, 4.25+(A1-1)*0.85)
so IF 1 contract is sold it will be $4.25 + (1-1) *0.85
so IF 2 contacts are sold it will be $4.25 + (2-1)*0.85
etc
Hi Wyn
That is awesome. Thank you so much for your help my friend
Anthony