Hi, there must be a way to do this.....
A = Cost Price
B = Selling Price
C = Selling Price ex. VAT (B/1.2)
D = Profit £ (C-A)
E = Profit % (D/C)
example:
A2 = 5.00
B2 = 15.00
C2 = 12.50
D2 = 7.50
E2 = 60 %
However, we can afford to price down to 30% Profit % which would make B2 (Selling...