" Back to Front" Calculation

[PERCH1]

Hello

I wonder if anyone can help with a little tricky calculation I just can't get to work as below :

I have a landed cost of $ 12 calculated as a result of other variables
I have freight and duty of 15% ( also variable )

i need a cell to calculate the FOB cost which when you add 15% to it should come back to $ 12 - you obviously can't just take 15% off the landed cost as the freight and duty is applied to the FOB cost

little bit confusing !

thanks
pete

 

[GlennUK]

Isn't it:
=12*100/115

( which is 10.43478 )?

 

[PERCH1]

hi glenn

tried =(G14*100)/(100+N5)

where G14 is landed cost of $12 and N5 is 15%

and I seem to get $ 11.98 when i should be getting in the region of 10.434

going wrong somewhere

thanks
pete

 

[GlennUK]

That's because you are using 15% instead of 15. If you want that cell to actually be 15% then use:

=G14/(1+N5)

 

[PERCH1]

glenn

marvellous - thanks ever so much

pete

 

[GlennUK]

My pleasure.