# formula for calculating Markup and Vat

1. ## 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. ## Re: formula for calculating Markup and Vat

Is this what you wanted?

3. ## 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. ## Re: formula for calculating Markup and Vat

Originally Posted by ianmb
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. ## 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. ## Re: formula for calculating Markup and Vat

Originally Posted by JeanRage
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

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

#### 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