I have a price list which i need to get back to cost price, then add a margin then add vat how do i, take off 20% add 40% and add vat to all the figures in the spreadsheet in one sum?

I am using a mac with lion os

thanks

simon

I have a price list which i need to get back to cost price, then add a margin then add vat how do i, take off 20% add 40% and add vat to all the figures in the spreadsheet in one sum?

I am using a mac with lion os

thanks

simon

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Hi there

Give this formula a try…

`=SUM(0.2*(ABS(A2/(100+20)*(100)-A2)*2+SUM(A2/(100+20)*(100))))*6`

I believe this should work. Where you see A2 reference in the formula swap it for the first cell reference that contains your price.