# Formula for (product price plus mark up) plus tax

1. ## Formula for (product price plus mark up) plus tax

good evening

May you please let me know the formula for let say the product price is \$100 with a mark up of 25%. then on a separate formula, the total of the product price plus the mark up then plus 9.5% tax.

The mark up and tax may change or vary so please let me know the correct formula.. For what ever reason, the formula that i created only works for 25% and when i change that to a different mark up percentage, the result is incorrect.

this is just an example as i have a boatload of products in my spreadsheet. MARK UP 25.00% TAX 9.50%

PRICE MARK UP IN \$ INITIAL TOTAL TAX IN \$ SUBTOTAL
\$40.00 \$10.00 \$50.00 \$4.75 \$54.75

formula used

MARK UP 0.25 TAX 0.095

PRICE MARK UP IN \$ INITIAL TOTAL TAX IN \$ SUBTOTAL
40 =(D5*\$E\$2)/(0.75+\$E\$2) =D5*(1+\$E\$2) =(F5*\$G\$2)/(1+\$C\$2) =F5*(1+\$G\$2)

thank you very much in advance for the assistance

Rennel Atienza  Register To Reply

2. ## Re: Formula for (product price plus mark up) plus tax

Good morning!

A sample sheet, showing EXACTLY the nature of the problem, would be a help. (See yellow banner at the top of the page). See if this gets you started, though.  Register To Reply

3. ## Re: Formula for (product price plus mark up) plus tax

If A2 = Price, B2 = Mark Up %, C2 = Price plus Mark Up, D2 = Tax %, E2 = Price plus Mark Up plus Tax
Then, C2 = A2*(1+B2) and E2 = C2*(1+D2)  Register To Reply

4. ## Re: Formula for (product price plus mark up) plus tax

Thanks Glen.. it worked.. I just had to change the tax formula to =(F32*\$G\$2)/(1+\$C\$2)  Register To Reply

5. ## Re: Formula for (product price plus mark up) plus tax

thanks Joseph..  Register To Reply

6. ## Re: Formula for (product price plus mark up) plus tax

You're welcome.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.  Register To Reply