ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Finding real values of a function (https://www.excelbanter.com/excel-worksheet-functions/5355-finding-real-values-function.html)

ruralkansas

Finding real values of a function
 
I am using Excel 97 and was told I can figure algebra problems with it. Any
ideas on how to solve an equation like:
f(x)=12-8x for x=-1; 0; and 1
or
y(x)=3(x-2)w/ exponent 1/2

Thanks! I can't find a function in the list that lets me use the variable x.

Frank Kabel

Hi
place your X variable values in column A (e.g. A1:A10)
in B1 enter
=12-8*A1
and copy this formula down

--
Regards
Frank Kabel
Frankfurt, Germany


ruralkansas wrote:
I am using Excel 97 and was told I can figure algebra problems with
it. Any ideas on how to solve an equation like:
f(x)=12-8x for x=-1; 0; and 1
or
y(x)=3(x-2)w/ exponent 1/2

Thanks! I can't find a function in the list that lets me use the
variable x.



All times are GMT +1. The time now is 02:13 AM.

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