ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Formulas (https://www.excelbanter.com/excel-worksheet-functions/177306-formulas.html)

Carlysummer

Formulas
 
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.

David Biddulph[_2_]

Formulas
 
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.





All times are GMT +1. The time now is 11:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com