Hey all,

I'm trying to work something out in excel, I don't even know if it is possible but if it were, It would definitely save a headache...

Basically it works like this...

Cell A1

12.23

Cell B1

A1 + 21% + 3% + 3.9% + 0.30 + 1.00 = 17.136696711

If that makes sense?

Basically the way I have it set out at the moment is I have 4 cells.

Wholesale (A1)

VAT Price

After Fees

Sale Price (Preferably B1)

I input the wholesale price in A1 which populates the other cells, I then edit a percentage which is in the Sale price cell until the difference between the VAT price and the After Fees price is 1.

This would give me a sale price which covers the wholesale price, the VAT, the fees and a profit of $1.

The example above would be as follows;

Wholesale$ + VAT% + Currency Pad% + Fee% + Fee$ + $1 =

Right now I'm working this out using a calculation based on 4 cells, I'd rather just work off A1 and input the answer into B1.

Any assistance appreciated!

I'm trying to work something out in excel, I don't even know if it is possible but if it were, It would definitely save a headache...

Basically it works like this...

Cell A1

12.23

Cell B1

A1 + 21% + 3% + 3.9% + 0.30 + 1.00 = 17.136696711

If that makes sense?

Basically the way I have it set out at the moment is I have 4 cells.

Wholesale (A1)

VAT Price

After Fees

Sale Price (Preferably B1)

I input the wholesale price in A1 which populates the other cells, I then edit a percentage which is in the Sale price cell until the difference between the VAT price and the After Fees price is 1.

This would give me a sale price which covers the wholesale price, the VAT, the fees and a profit of $1.

The example above would be as follows;

Wholesale$ + VAT% + Currency Pad% + Fee% + Fee$ + $1 =

Right now I'm working this out using a calculation based on 4 cells, I'd rather just work off A1 and input the answer into B1.

Any assistance appreciated!

Last edited by a moderator: