Hi all

I have created a spreadsheet (attached) to determine my Store Price based on what profit I set.

For example there are currently Four Columns.

Column A = Product price from my supplier
Column B = Store Price, i.e. the Price I will sell to end user - Formula: =(E2+0.2+A2)/0.966
Column C = Paypal Fees (20p + 3.4%) - Formula: =0.2+0.034*B2
Column D = Profit Required after all fees

This allows me to set the profit I require after all fees in Column D and works brilliantly. However I now need to add a 10% Commission Fee to the final Selling Price in Column B, but still receive the same profit from Column D after all fees.

I have hopefully explained this correctly. Can anyone help?

paypal equation.xlsx