formula creation

[Anthony Verner]

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 trade more than 1 contract the commission is $0.85 per additional contract

My aim is to have a cell that can calculate my total commissions depending on how many contracts I trade.

Thanks in advance for your input

Anthony

[#2]

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

[#3]

Hi Wyn

That is awesome. Thank you so much for your help my friend

Anthony