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

Is this what you wanted?

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?

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?

Hi,

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

HTH

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