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

One thought on “Calculate Cost Price, Add Margin and VAT in Single Formula

  1. andrew walker Post author

    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.

Leave a Reply

Your email address will not be published. Required fields are marked *