Forum Discussion
Christian D. MacRae
Jan 10, 2018Copper Contributor
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:
(...
- 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
Christian D. MacRae
Jan 10, 2018Copper Contributor
Thank you so much Damien; worked like a charm! I really appreciate it!
Christian
Damien_Rosario
Jan 10, 2018Silver Contributor
Hi Christian
Happy to help!
Could you mark it as your preferred answer so that other visitors will know the solution has worked?
All the best.
Cheers
Damien
Happy to help!
Could you mark it as your preferred answer so that other visitors will know the solution has worked?
All the best.
Cheers
Damien