Thanks:  0
Likes:  0

1. 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 %.

2. 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)

3. 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)

4. 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 !!!!

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•