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

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

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,053
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
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,053
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
Can you please explain how to do this? where do i plug these formulas in?
 

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
8,053
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,170,946
Messages
5,872,885
Members
432,952
Latest member
CincyExcel1

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