+ Reply to Thread
Results 1 to 6 of 6

Formula for (product price plus mark up) plus tax

  1. #1
    Registered User
    Join Date
    09-25-2015
    Location
    oakland, california
    MS-Off Ver
    MS 10
    Posts
    5

    Post 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

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    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.
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    2,957

    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)
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    09-25-2015
    Location
    oakland, california
    MS-Off Ver
    MS 10
    Posts
    5

    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)

  5. #5
    Registered User
    Join Date
    09-25-2015
    Location
    oakland, california
    MS-Off Ver
    MS 10
    Posts
    5

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

    thanks Joseph..

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

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

    You're welcome.



    If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 9
    Last Post: 11-13-2017, 04:33 AM
  2. [SOLVED] Excel Cell To Show Product Price But With A Minimum Price
    By icemoose in forum Excel General
    Replies: 6
    Last Post: 05-04-2016, 06:46 AM
  3. Formula to add diferent mark ups based on origina price
    By Ricky.Sherman in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-04-2015, 07:04 PM
  4. calculate retail price based on mark up on cost price
    By pvl in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 07-27-2014, 03:49 AM
  5. Replies: 1
    Last Post: 07-24-2013, 12:13 PM
  6. [SOLVED] Variable product and price formula
    By Onesock in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-14-2013, 10:13 AM
  7. Mark the Lowest price in a price-matrix
    By raed_237 in forum Excel General
    Replies: 8
    Last Post: 04-07-2009, 01:24 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1