Is this Tricky calcualtion Possible?

rubyh

Board Regular
Joined
Mar 31, 2006
Messages
213
Hey guys,
I havent been here in a while thanks to all the previous help over the past. but heres a stumper.

Im trying to come up with a formula to mark up cell A1 enough so that C1 would equal to 10% of B1. No matter what cost price is in B1.
Book1
ABCDEFG
1PriceCostPRFeeRatemisc 1MISC 2
2$112.3197.5$8.75$1.12$3.650.251
3$32.5928.3$1.65$0.33$1.060.251
Sheet1
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

jblackburn

New Member
Joined
Sep 19, 2006
Messages
15
Try to use the solver. I have not used the solver much but I do know that you set any cell to always = "x" in your case "X" would need to be set at 10% of A1.
 

rubyh

Board Regular
Joined
Mar 31, 2006
Messages
213
cant do that in C2 its already minusing values from other cells how am i to do that?
 

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
8,010
Office Version
  1. 365
Start with 0.1B = A - B - 0.01A - 0.0325A - 0.25 - 1

...add some algebra here...

end with A = 1.148825B + 1.305483
 

rubyh

Board Regular
Joined
Mar 31, 2006
Messages
213

ADVERTISEMENT

Start with 0.1B = A - B - 0.01A - 0.0325A - 0.25 - 1

...add some algebra here...

end with A = 1.148825B + 1.305483

HUH???? im even more confused now
 

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
8,010
Office Version
  1. 365
C2 =SUM(A2-E2-F2-G2-B2-D2)

D2 = 0.01*A2
E2 = 0.0325*A2
F2 = 0.25
G2 = 1

So, substituting, you get:

C2 = A2 - 0.0325*A2-0.25-1-B2-0.01*A2

You want C2 = 0.1*B2

So, (rearranged) :

0.1B = A - B - 0.01A - 0.0325A - 0.25 - 1

Using some algebra to solve for A, your formula in A2 = 1.148825B2 + 1.305483 per my last post
 

rubyh

Board Regular
Joined
Mar 31, 2006
Messages
213

ADVERTISEMENT

Can you please explain how to do this? where do i plug these formulas in?
 

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
8,010
Office Version
  1. 365
Just replace A2's formula with = 1.148825*B2 + 1.305483. Then, when you adjust B2 to whatever value you'd like, A2 (and subsequently C2) will adjust accordingly.

edit: added *
 

rubyh

Board Regular
Joined
Mar 31, 2006
Messages
213
This is what i have but everytime i enter that formula in A2 i get a formula error not being correct.
Book2
ABCD
1PriceCostPRFee
2=1.148825B2+1.30548350#VALUE!
Sheet1
 

Forum statistics

Threads
1,136,519
Messages
5,676,333
Members
419,619
Latest member
jalme

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
Top