Forum Discussion
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:
((2*Cell)-4%)+47
A very easy calculation; yet when it is input into a cell as a formula, the resultant number is not what my calculator shows; I have been getting a little batty on it and obviously am missing something.
Could someone please help me find what I am doing wrong? I have googled a ton and nothing seems to resolve this calculation, as I say, I must be missing something.
Thanks
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
3 Replies
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
Thank you so much Damien; worked like a charm! I really appreciate it!
Christian
- 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
