# 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  Register To Reply

2. ## Re: formula for calculating Markup and Vat

Is this what you wanted?  Register To Reply

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?  Register To Reply

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?  Register To Reply

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  Register To Reply

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  Register To Reply