Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 30th 04, 06:11 AM
ruralkansas
 
Posts: n/a
Default 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.

  #2   Report Post  
Old October 30th 04, 09:14 AM
Frank Kabel
 
Posts: n/a
Default

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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Second serie doesn't use X-as values JackRnl Charts and Charting in Excel 1 January 20th 05 01:04 AM
LOOKUP FUNCTION WITH SUMS VALUES Jamesy Excel Discussion (Misc queries) 3 January 10th 05 03:03 PM
Finding Values in a "Matrix" Diane Alsing Excel Discussion (Misc queries) 8 December 31st 04 08:21 PM
need to save values from a function before it changes Ron Excel Worksheet Functions 1 October 29th 04 06:29 AM
SUMIF(AND) FUNCTION Saariko Excel Worksheet Functions 9 October 28th 04 11:52 AM


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

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017