Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Getting the equation of the trend line onto the excel sheet | Excel Discussion (Misc queries) | |||
How do a make a graph from an equation on excel? | Charts and Charting in Excel | |||
Excel 2003 doesn't display the proper equation with trendlines | Charts and Charting in Excel | |||
How can I use Excel to solve an equation? | Excel Worksheet Functions |