Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I need to make a formula in which I can find the value of x. Here is a
sample equation: (x+2)/x=10 Any help would be appreciated. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
You could use a formula like =(A1+2)/A1 and then use Tools/ Goal Seek to aim
for a value of 10 in the result cell by changing A1 (but that will only approximate iteratively). Better to use some algebra: (x+2)/x=10 (x+2)=10*x 2=9*x 2/9=x -- David Biddulph "Carlysummer" wrote in message ... I need to make a formula in which I can find the value of x. Here is a sample equation: (x+2)/x=10 Any help would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |