# Is this Tricky calcualtion Possible?

#### rubyh

##### Board Regular
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 can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
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.

cant do that in C2 its already minusing values from other cells how am i to do that?

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

end with A = 1.148825B + 1.305483

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

end with A = 1.148825B + 1.305483

HUH???? im even more confused now

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

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

ok ill try that out thanks

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.

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

Replies
0
Views
590
Replies
3
Views
2K
Replies
1
Views
1K

1,218,620
Messages
6,143,523
Members
450,492
Latest member
Rusbus1972

### 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.

### Which adblocker are you using?

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

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