Hi guys
I'm looking for a way to solve this formula in Excel:
x = (12600+0.1x)*100 / 40
(x would be 42'000).
How can I calculate in Excel?
Thanks!
Hi guys
I'm looking for a way to solve this formula in Excel:
x = (12600+0.1x)*100 / 40
(x would be 42'000).
How can I calculate in Excel?
Thanks!
IMO, before it can be a programming problem, it needs to be an algebra problem. Dust off the algebra you learned back in early secondary school, solve the equation for x, then you will have a relatively simple formula you can program into Excel. If you need a tutorial to refresh you memory of solving these kinds of equations, I like this one: https://www.purplemath.com/modules/solvelin3.htm
Can we assume you can solve the algebra, or do you need help with the algebra?
Originally Posted by shg
Hi Mr. Shorty
Thanks for your quick response. I know how to solve the algebra by hand (stepbystep extracting the x), but I was wondering how I can calculate this with Excel?
you need excel solver
One can use Solver for this sort of thing, especially if this is a one time task. Long term I prefer to solve the algebra expression and enter the appropriate formula.
You indicate that you can solve the algebra for x, but are not sure how to program that expression in Excel? I would expect that x=expression consists of simple add, subtract, multiply, divide operations. What do you get for you x=expression? What questions do you have about entering that expression into Excel?
I agree that a formula would be better here.
Walk us through the steps you would use to do this with pen and paper - we can then work a formula around that logic.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
To get a more accurate result even if 1.71931E-08 is pretty close to zero change tim's setting a bit i.e.
Set A1 to "Min" and add the constraint
AlfPlease Login or Register to view this content.
I agree, I'd be very curious to solve this with a formula. Here's a step by step resolution (in German, but you get the idea)
Attachment 646016
Nothing attached.
To attach a sheet click "Go advanced" and scroll down to "Manage attachments" and follow the instructions
And while you are at it:
-although we value privacy as much as anyone else, it could be important that members have a rough idea of your location. You might in the future post questions which are bound to your regional settings.
So, please update your profile ( country will suffice, no need to be more precise).
Thank you for helping us to help you
- Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.
Thanks
If formula is "x=(12600+0.1x)*100/40 that can be changed to "x=(12600+0.1x)*10/4"
Then multiply both side of equation with 4 and multiply left side of equation with 10 changes expression to "4x=126000 +x". Then move all x'es to right side of equation and expesssion now
becomes "4x-x= 126000"
And "x = 126000/3" so x = 42000
Alf
Thanks Alf for solving it. Now, the 0.1x equals to 10% and should be a variable since it can change.
Here is the most general construction:
A1: 12600
B1: 0.1 or 10% (equivalent)
C1: 100
D1: 40
X1: =A1*C1 / (D1 - B1*C1)
Y1 (check: should return TRUE): =X1 = (A1 + B1*X1)*C1 / D1
Derivation:
X1 = (A1 + B1*X1)*C1 / D1
D1*X1 = A1*C1 + B1*C1*X1
X1*(D1 - B1*C1) = A1*C1
X1 = A1*C1 / (D1 - B1*C1)
Wow, thank you very much. It was really about solving the formula first. Grande, many thanks.
Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.
Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks