BensGrandad
New member
I am helping a friend do his stocktake and we need to calculate the GP % of each item. I know I could do it manually but for 200 items it would take an age.
Does any body know the formula to use for excel ;
The calculation is Selling Price -17.5% (vat) minus cost price divided by the selling price and the %.
Or
£2.50(selling price) - £0.85(vat) = £1.65 - cost of £1.10 = Profit of 55p, divided by the Selling price ex vat £1.65 = 33.3%. How do I do this as a formula substituting cell numbers for the actual numbers shown. Many thanks for any help.
Does any body know the formula to use for excel ;
The calculation is Selling Price -17.5% (vat) minus cost price divided by the selling price and the %.
Or
£2.50(selling price) - £0.85(vat) = £1.65 - cost of £1.10 = Profit of 55p, divided by the Selling price ex vat £1.65 = 33.3%. How do I do this as a formula substituting cell numbers for the actual numbers shown. Many thanks for any help.