Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 189
Default how can I solve two equation with excel?

how can I solve two equation with excel?
example:
x+y=1
4x-2y=5
x=?
y=?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 947
Default how can I solve two equation with excel?

One way is to select 2 vertical cells, and Array Enter:

=MMULT(MINVERSE({1,1;4,-2}),{1;5})

or as ranges:
=MMULT(MINVERSE(A1:B2),C1:C2)

--
HTH :)
Dana DeLouis
Windows XP & Office 2003


"peyman" wrote in message
...
how can I solve two equation with excel?
example:
x+y=1
4x-2y=5
x=?
y=?



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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Getting the equation of the trend line onto the excel sheet Farooq Sheri Excel Discussion (Misc queries) 4 November 17th 06 04:10 PM
How do a make a graph from an equation on excel? Amber Charts and Charting in Excel 1 October 25th 06 12:53 PM
Excel 2003 doesn't display the proper equation with trendlines wsander2 Charts and Charting in Excel 2 October 18th 06 02:03 AM
How can I use Excel to solve an equation? titina Excel Worksheet Functions 4 April 11th 06 11:19 PM


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

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"