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

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

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

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

is it possible to enter y into equation??
 

email address is


--
danepak86
------------------------------------------------------------------------
danepak86's Profile: http://www.excelforum.com/member.php...o&userid=29323
View this thread: http://www.excelforum.com/showthread...hreadid=490411