not EXCEL related - program to convert an equation

[Qroozn]

Guys,
Im an avid mrexceller - and this is something well beyond excel. But i hope you have some ideas.

I am trying to find a program that will convert my equation so that rather than getting a Result based o the variables... it can me run and will give me the variable that gives me the result.

take a look below. This is a VERY simple example.

X = y + 1. now if i know the value of X but i want to find Y then i want it to tell me Y = X - 1.

the formula i am ACTUALLY trying to get is
sashwidth = =($E$4*POWER($A8,3))/($B$4*B$1*SQRT((4*POWER($A8,2))-POWER(B$1,2))*((2*POWER($A8,2))-POWER(B$1,2))).

where i know sashwidth, but i dont know B$1.

can anyone direct me to a program that could be used? or is this a business opportunity at my fingertips?


Thanks
Colin

 

[Tazguy37]

One program I do know of that can do this kind of thing is MathCAD. A google search will probably turn up more.

 

[tactps]

you should be able to use "solver" or "goal seek" to determine the variables.

 

[Qroozn]

thanks for the reply.

i found what i was looking for at this site.


http://www.hostsrv.com/webmab/app1/...e?site=mathcom&s1=equations&s2=solve&s3=basic

it does a fantastic job and strongly reccommend it.

 

[tactps]

Looks cool.

Glad you were able to track it down.