Forum Discussion

Christian D. MacRae's avatar
Christian D. MacRae
Copper Contributor
Jan 10, 2018
Solved

Dues Calculation

Hi There,   I am trying to configure a formula to auto-calculate a membership dues which is based off the following: (2 x Hourly Rate)-4% + $47   I have been entering it into a cell as: (...
  • Damien_Rosario's avatar
    Jan 10, 2018

    Hi Christian

     

    Try this formula:

     

    =SUM(((2*Cell)-((2*Cell)*0.04)+47))

     

    Essentially the first brackets are 2x Hourly Rate MINUS 4% of the 2x Hourly rate PLUS 47.

     

    Hope that helps!

     

    Cheers

    Damien

Resources