Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I am trying to find X in the formula X+(X*i)=Y+S
I´m trying to write a formula in excel but I can´t find the way to obtain the
result! Maybe this kind of operation is not available in excel but I would like to know if It is possible. X=? the values of i, Y and S are known. X+(X*i)=Y+S Best Regards ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...el.programming |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
I am trying to find X in the formula X+(X*i)=Y+S
Grüezi Jorge
Jorge schrieb am 02.02.2006 Maybe this kind of operation is not available in excel but I would like to know if It is possible. X=? the values of i, Y and S are known. X+(X*i)=Y+S This kind of operation is not available - you have to 'redisign' your formula in an algebraic way that X is alone on one side of the '='-Sign. A possibility is the following: X=(Y+S)/(1+i) now you can repalce the variables with cell-references. Regards Thomas Ramel (@work) -- - MVP for Microsoft-Excel - [Win XP Pro SP-2 / xl2000 SP-3] Microsoft Excel - Die ExpertenTipps: (http://tinyurl.com/9ov3l und http://tinyurl.com/cmned) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
I am trying to find X in the formula X+(X*i)=Y+S
Hi
This one is easy, X = (Y+S)/(1+i) I suspect you mean to solve X + X^i = Y + S This can be solved using GoalSeek: 1. Put any value of X you like in A1 eg 1. Put values of i, S and Y in A2, A3 and A4 respectively 2. In A2 write the formula = A1+(A1*A2)-A3-A4 (so that you are solving X + (X*i) - S - Y = 0) 3. Go to Tools, GoalSeek.. and set Cell A2 to 0 by changing cell A1. regards Paul |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
I am trying to find X in the formula X+(X*i)=Y+S
Jorge,
I do like the algebraic solution. However, there are some cases when you can't solve your equation algebraically or when it's beyond your abilities to solve. In those cases, I'd suggest that you use the Goal Seek tool. I set up a simple spreadsheet like this: A1: X B1: 3.3 A2: i B2: 2.5 A3: y B3: 4.1 A4: s B4: 8.7 Then I added a formula in A6, which is the left-hand side of your equation: A6: =B1+B1*B2. And a formula in B6, which is the right-hand side of your equation: B6: =B3+B4 And then a difference in C6: C6: =A6-B6 When C6 is 0, you will have a solution for your equation. Here's how to use the Goal Seek tool: From the menu, choose Tools - Goal Seek... Fill in the Goal Seek pop-up as follows: Set cell: C6 To value: 0 By changing cell: B1 Excel will iterate until it finds a solution, and replace B1 with 3.647143. If it cannot find a solution, it will tell you as much. Jorge wrote: X=? the values of i, Y and S are known. X+(X*i)=Y+S |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
I am trying to find X in the formula X+(X*i)=Y+S
X=(Y+S)/(i+1 )
"Jorge" wrote: I´m trying to write a formula in excel but I can´t find the way to obtain the result! Maybe this kind of operation is not available in excel but I would like to know if It is possible. X=? the values of i, Y and S are known. X+(X*i)=Y+S Best Regards ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...el.programming |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to find formula for.... | Excel Worksheet Functions | |||
Need to find a formula | Excel Worksheet Functions | |||
Need Help With A Find Formula | Excel Worksheet Functions | |||
Lookup Formula - but have a formula if it can't find/match a value | Excel Worksheet Functions | |||
Can you help to find the right formula? | Excel Programming |