+ Reply to Thread
Results 1 to 6 of 6

formula for calculating Markup and Vat

  1. #1
    Registered User
    Join Date
    02-03-2010
    Location
    malta
    MS-Off Ver
    Excel 2003
    Posts
    46

    formula for calculating Markup and Vat

    Hi,

    I am doing a list of selling prices for producrts which have the same ,markup. Basically I have done the cost price in 1 column and the markup and VAT rate in 2 seperate cells (so that I can change without changing all the formulas).

    How can i do the formula to for example a cost price of 50.00 is marked up by 35% and Vat is added on it?

    Thanks

    Ian

  2. #2
    Forum Contributor
    Join Date
    07-24-2009
    Location
    Valrico, FL USA
    MS-Off Ver
    Excel 2016
    Posts
    358

    Re: formula for calculating Markup and Vat

    Is this what you wanted?
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    02-03-2010
    Location
    malta
    MS-Off Ver
    Excel 2003
    Posts
    46

    Re: formula for calculating Markup and Vat

    Hi

    Thanks for the reply, I am doing the formula like this =D7*(1+$I$4)*(1+I5) where D7 is the cost price, I4 is the cost price and I5 is the Vat, both in seperate cells and quoted as a percentage. Is myway correct?

  4. #4
    Registered User
    Join Date
    02-03-2010
    Location
    malta
    MS-Off Ver
    Excel 2003
    Posts
    46

    Re: formula for calculating Markup and Vat

    Quote Originally Posted by ianmb View Post
    Hi

    Thanks for the reply, I am doing the formula like this =D7*(1+$I$4)*(1+I5) where D7 is the cost price, I4 is the cost price and I5 is the Vat, both in seperate cells and quoted as a percentage. Is myway correct?

    Hi

    Is the above way correct?

  5. #5
    Valued Forum Contributor JeanRage's Avatar
    Join Date
    03-02-2009
    Location
    Nice, France
    MS-Off Ver
    Excel 2003
    Posts
    705

    Re: formula for calculating Markup and Vat

    Hi,

    If you mean cell I4 holds your mark-up in % and I5 your VAT rate in %, your formula is then correct ...

    HTH

  6. #6
    Registered User
    Join Date
    02-03-2010
    Location
    malta
    MS-Off Ver
    Excel 2003
    Posts
    46

    Re: formula for calculating Markup and Vat

    Quote Originally Posted by JeanRage View Post
    Hi,

    If you mean cell I4 holds your mark-up in % and I5 your VAT rate in %, your formula is then correct ...

    HTH

    hi yes i4 contains the mark up (and not the cost price) and i5 the Vat rate both in percent

    Thanks

    Ian

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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