Can This Be Solved?

  • Thread starter Thread starter IC_Clearly
  • Start date Start date
I

IC_Clearly

I'm not sure if this can be solved, but any help would sure be appreciated.

I start with a given number. Let's say 200. I need to find the number that
will yield 200 when I subtract the following; multiply by 10% and add 10.
In this case the number is 233.33.

233.33
x 10%=
23.33
+10
=33.33

233.33-33.33=200

I am looking for a formula that will give me 233.33 when I enter 200.
Again, if this can be solved, any suggestions would be appreciated.

Thanks much.

IC
 
In algebra, your formula is:

200 = x * (1 - .10) - 10
200 + 10 = .9x
x = (200 + 10) / .9

In Excel, if 200 is in A1,
B1 = (a1+10)/.9
 
Hello IC,
Fred has given you the correct answer. But for the mathematically
challenged, Excel has the Goal Seek feature (look under Tools). This is used
to solve math problems "backwards"
In A1 enter a guess for your answer, say 180
In A2 enter =A1-10%*A1-10 Since we have use % Excel will format the cell as
percent, so formatted it as general
Start Goal Seek; the Set Cell is A2, the Value is 200, the By Changing cells
is A1
You get 200.3333 as the answer

Best wishes
 
Back
Top