Forum Discussion

Anthony Verner's avatar
Anthony Verner
Copper Contributor
May 17, 2017

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 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

Formulas & Functions
Need Help

2 Replies

Sort By
  • Wyn Hopkins's avatar
    Wyn Hopkins
    MVP
    May 17, 2017

    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

    • Anthony Verner's avatar
      Anthony Verner
      Copper Contributor
      May 17, 2017

      Hi Wyn

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

      Anthony

Resources