If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
is it possible to enter y into equation??
is it possible for excel to solve an equation e.g. 3y=y+1 to find y?? if so how is it done? we would greatly appreciate any help!!! Many Thanks -- danepak86 ------------------------------------------------------------------------ danepak86's Profile: http://www.excelforum.com/member.php...o&userid=29323 View this thread: http://www.excelforum.com/showthread...hreadid=490411 |
#2
|
|||
|
|||
is it possible to enter y into equation??
Let's say y is in A1. In B1: =3*A1. In C1: =A1+1
In D1: =B1-C1 Select D1. ToolsGoal seek. Set cell should be D1, in To Value enter 0, By Changing cell : A1 -- Kind regards, Niek Otten "danepak86" wrote in message ... is it possible for excel to solve an equation e.g. 3y=y+1 to find y?? if so how is it done? we would greatly appreciate any help!!! Many Thanks -- danepak86 ------------------------------------------------------------------------ danepak86's Profile: http://www.excelforum.com/member.php...o&userid=29323 View this thread: http://www.excelforum.com/showthread...hreadid=490411 |
#3
|
|||
|
|||
is it possible to enter y into equation??
thanks for your help, however when we follow your instructions it comes up with the following error, "formula in cell must result in a number" is it actually possible to find y? e.g. 3Y=Y+1 2Y=1 Y=0.5 Can excel tell us that y is 0.5 in this example? -- danepak86 ------------------------------------------------------------------------ danepak86's Profile: http://www.excelforum.com/member.php...o&userid=29323 View this thread: http://www.excelforum.com/showthread...hreadid=490411 |
#4
|
|||
|
|||
is it possible to enter y into equation??
If you mail me your email address I'll send you the sheet that I tested and
that indeed found y = 0.5 -- Kind regards, Niek Otten "danepak86" wrote in message ... thanks for your help, however when we follow your instructions it comes up with the following error, "formula in cell must result in a number" is it actually possible to find y? e.g. 3Y=Y+1 2Y=1 Y=0.5 Can excel tell us that y is 0.5 in this example? -- danepak86 ------------------------------------------------------------------------ danepak86's Profile: http://www.excelforum.com/member.php...o&userid=29323 View this thread: http://www.excelforum.com/showthread...hreadid=490411 |
#5
|
|||
|
|||
is it possible to enter y into equation??
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Criteria All Records | Robert Raley | Running & Setting Up Queries | 4 | August 28th, 2005 05:32 PM |
Problem with Equation Display | Doug | General Discussion | 3 | August 26th, 2005 02:48 AM |
Is there a (non-binary) "if x then enter y" forumula? | Julie P. | Worksheet Functions | 9 | June 21st, 2005 08:49 PM |
Pressing the Enter Key | kbrad | Using Forms | 2 | February 23rd, 2005 12:13 PM |
Equation Editor problems | Graeme Milne | New Users | 2 | June 25th, 2004 01:12 PM |