Maths question

Jubjab

Well-known Member
Joined
Jan 3, 2007
Messages
995
Hi,

My math is rotten :oops: , and I have formula I need to work out. It goes like this:

Code:
X = X*16,7% + (x - x/1,22) + 15000

Can I work out the value of X here? I need the formula to use in my spreadsheet.

Thanks!
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
Here is a hint. Get all the X values on one side of the equation, and your constant on the other side. Then you can factor out the X, and things should fall into place.
 
Upvote 0
Here is a hint. Get all the X values on one side of the equation, and your constant on the other side. Then you can factor out the X, and things should fall into place.

Well... I know what I am supposed to do, but I have forgotten how exactly to do that!
 
Upvote 0
Course you could just start with solving for 0 and minus x from the left. ;)

Seriously, is this homework?
 
Upvote 0
Is X a different variable than x? The commas are like decimals in the US, right?

Assuming the X and x are the same value, it looks like you're trying to incrementally increase X by the statement on the right as if it was in a loop:

if X had equaled 1 before, it would now equal 15000.35
next,
if X equaled 15000.35, it would now equal 20210.04
next,
if x equaled 20210.04, it would now equal 22019.51 etc...

Does that even make any sense??
Max
 
Upvote 0
Hi Jubjab,

You've got upper-case & lower-case x values - are they meant to be the same? It makes a fundamental difference to the solution.

Cheers
 
Upvote 0
Assuming X and x are the same values there really is no formula because the equation has to equal.

You get X=22982.4429206541

If X and x are different I suggest using a different variable, maybe Y
so

X = X*16.7% + Y - Y/1.22 + 15000
EQUALS

.833X=.22Y/1.22 + 15000
EQUALS
X=(.22Y/1.22+15000)/.833
 
Upvote 0
Or, more fully:

X = X*16,7% + (x - x/1,22) + 15000
X = X*16,7% + x*(1 - 1/1,22) + 15000
X - X*16,7% = x*(1 - 1/1,22) + 15000
X*(1 - 16,7%) = x*(1 - 1/1,22) + 15000
X*83,3% = x*(1 - 1/1,22) + 15000
X = x*(1 - 1/1,22)/83,3% + 15000/83,3%
X = x*(1 - 0,81967213114754098360655737704918)/83,3% + 15000/83,3%
X = x*0,18032786885245901639344262295082/83,3% + 15000/83,3%
X = x*0,21648003463680554188888670222187 + 18007,202881152460984393757503001

If we can assume X = x, then:

X - X*0,21648003463680554188888670222187 = 18007,202881152460984393757503001
X*(1-0,21648003463680554188888670222187) = 18007,202881152460984393757503001
X*0,783519965363194458111113297779 = 18007,202881152460984393757503001
X = 18007,202881152460984393757503001/0,783519965363194458111113297779
X = 22982,4429206540577198402531836

Cheers
 
Upvote 0

Forum statistics

Threads
1,225,358
Messages
6,184,497
Members
453,236
Latest member
Siams

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