help with GP% formula relating to more than one cell

[Keyss]

Hi

I need to know, if possible, I can do this please.

I have 4 columns that relate to a sales formula;

D = Retail Price (fixed value derived from report)
F = Contract Price (fixed value only derived from report)
H = Cost Price (fixed value derived from report)
I = GP% (has formula as below)

so GP% is based using (F) Contract price if there is one or Retail Price if not.

Formula in GP% column

=iferror((f2-h2)/f2*100,(d2-h2)/d2*100)

What I am trying to work out is if there is a way that I can enter a value in the GP% column that will then provide a new Contract or Retail Price based on the entered GP% (GP% expressed as 32 for 32%)

I realise the formula I would need to use is Sell = Cost/(1-GP%)

2 questions;
- can this be done
- can this work when there is already the above formula in the GP% column/cell


Thanks in advance