tricky formula

G

Guest

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

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
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)
 
Upvote 0
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)
 
Upvote 0
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 !!!!
 
Upvote 0

Forum statistics

Threads
1,213,494
Messages
6,113,986
Members
448,538
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top