tricky formula

I am trying to write a formula which will give me the whole sale cost working backwards from the retail price given the % mark up required. For example an iten reatiling for $6.00 need to wholesale at $3.16 at a 90% markup. I have writen a siple formula which divides the reail cost by 1.9 which gives me the right answer, What I need is a formula where I can vary the %.

[Paul-Johnson]

You could use a cell address in your formula where you placed the %, and then change the value in the cell address.

For example

B2 is the cost a1 is the %. Change a1's value and the formula will change.
=(b2*a1)

I have tried this but it does not give the correct answer ?

On 2002-02-23 18:54, Paul-Johnson wrote:
You could use a cell address in your formula where you placed the %, and then change the value in the cell address.

For example

B2 is the cost a1 is the %. Change a1's value and the formula will change.
=(b2*a1)

EUREKA - I've solved my own problem.
If A1 contains the retail cost and B1 the % then this formula works =A1/(B1+1)
So simple really !!!!