Calculate Cost Price, Add Margin and VAT in Single Formula

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

951 thoughts on “Calculate Cost Price, Add Margin and VAT in Single Formula

Comments are closed.