Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Solving for x
i would like to know if it is possible to get excel to work out an unknown
value. I need to know what the value of a certain cell should be in order to when multiplied by another cell is equal to a third. like : 'D12 =B4*x-E9=0' so in other words would it be able to do something like solving for x were 20x-40=0 Many thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Solving for x
In your example, x=E9/B4 and if you always want a result of zero, then this
formula will work. In the more general case of y=mx+c x=(y-c)/m 0=B4*x-E9 0-(-E9)=B4*x x=E9/B4 HTH "stew12" wrote: i would like to know if it is possible to get excel to work out an unknown value. I need to know what the value of a certain cell should be in order to when multiplied by another cell is equal to a third. like : 'D12 =B4*x-E9=0' so in other words would it be able to do something like solving for x were 20x-40=0 Many thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Problem Solving | Excel Worksheet Functions | |||
Solving for multiple algebraic variables | Excel Worksheet Functions | |||
solving for 2 unknowns using 2 simultaneous equations | Excel Discussion (Misc queries) | |||
solving for 3 unknowns using 3 simultaneous equations | Excel Discussion (Misc queries) | |||
solving for NPer w/o function (algebra question) | Excel Worksheet Functions |