![]() |
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. |
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