Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
ruralkansas
 
Posts: n/a
Default Help w/ algebra equations (wrong formula used in my first 2 posts!

Can Excel 97 find the x-values of an equation such as

5x - 2 = 0
or
9x[squared] - 6x = -1
or
1 over x-3 = 2 over x+3 minus 4(x over x[squared] - 1)

What about quadratic equations??

Thanks!
  #2   Report Post  
Jerry W. Lewis
 
Posts: n/a
Default

Excel does not do symbolic algebra. Excel can numerically solve
equations using the Solver tool (see Help).

Jerry

ruralkansas wrote:

Can Excel 97 find the x-values of an equation such as

5x - 2 = 0
or
9x[squared] - 6x = -1
or
1 over x-3 = 2 over x+3 minus 4(x over x[squared] - 1)

What about quadratic equations??

Thanks!


  #3   Report Post  
Ken Wright
 
Posts: n/a
Default

For your example

1 over x-3 = 2 over x+3 minus 4(x over x[squared] - 1)

As Jerry said, take a look at Solver.

You can set up each side of the equation as a separate formula with x being a
cell reference (I'll assume A1) with a dummy value in it. This means you now
have two cells with a formula in them (I'll assume A3 and B3), each referring to
cell A1 for the x portion, and at the moment each giving you a different answer.
Now in a fourth cell, say C3, put =B3-A3 and this will simply display the result
of one minus the other. For your equation to solve for the value of x you need
the two sides of the formula to be equal, which means cell C3 should be 0. Now
just tell Solver to set cell C3 to 0 by changing the value in cell A1.

This really does take the fun out of equations though, as it would be quicker
and more enjoyable to solve it with pen and paper than it would to set it up in
Excel.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"ruralkansas" wrote in message
...
Can Excel 97 find the x-values of an equation such as

5x - 2 = 0
or
9x[squared] - 6x = -1
or
1 over x-3 = 2 over x+3 minus 4(x over x[squared] - 1)

What about quadratic equations??

Thanks!



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.784 / Virus Database: 530 - Release Date: 27/10/2004


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
revert formula insertion to old method Don't be a pain in the ass Setting up and Configuration of Excel 0 January 24th 05 02:49 PM
Simple formula doesn't quite add up circeo Excel Discussion (Misc queries) 3 January 17th 05 10:04 PM
Paste is is copying in formula, but display is wrong. Matt Excel Discussion (Misc queries) 2 December 7th 04 09:37 PM


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

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

About Us

"It's about Microsoft Excel"