Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Algebra in Excel
Is there a way to calculate algebraic equations in Excel?
I have the equation: 50a+100b=60 and 100a+50b=45 I know how to solve these by hand, but is there a way to solve them in Excel? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Algebra in Excel
Is there a way to calculate algebraic equations in Excel?
I have the equation: 50a+100b=60 and 100a+50b=45 I know how to solve these by hand, but is there a way to solve them in Excel? First Equation ============= Put the coefficient of 'a' in A1, the coefficient of 'b' in B1 and the constant in C1 Second Equation ============= Put the coefficient of 'a' in A2, the coefficient of 'b' in B3 and the constant in C2 Solution for 'a' ============= A4: =(B2*C1-B1*C2)/(A1*B2-A2*B1) Solution for 'b' ============= A5: =(C1-A4*A1)/B1 Notice the dependency in A5's calculation on the cell A4 (in case you decide to move the solution cell for 'b' to some other location). Rick |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Algebra in Excel
Why not to exploit useful math features of Excel?
Generally (it applies for arbitraly count of linear equations) and comfy: arrange your set of coefficients as follows 50 100 100 50 60 100 45 50 50 60 100 45 e.g. in the second and third arrays replace the first and second column with the coefficients from the right side. Apply Excel function MDeterm for each of these arrays (called square matrix) as arguments. And now simply divide the second (-1500) and third (-3750) results of this function by the first one (-7500) whereby you obtain your values for a (0.2) and b (0.5). Regards Petr "sstexas" wrote: Is there a way to calculate algebraic equations in Excel? I have the equation: 50a+100b=60 and 100a+50b=45 I know how to solve these by hand, but is there a way to solve them in Excel? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Algebra in Excel
On Jun 20, 11:55 am, sstexas
wrote: Is there a way to calculate algebraic equations in Excel? I have the equation: 50a+100b=60 and 100a+50b=45 I know how to solve these by hand, but is there a way to solve them in Excel? Look at Tools Solver. It solved those equations easily. For example, blank out A1 and B1, and put the following formula into C1: =50*A1 + 100*B1 Click on Tools Solver, set Target Cell to $C$1, set Equal to Value of 60, and set By Changing Cells to $A$1:$B$1. Then click on Solve. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use Algebra grafting? | Excel Discussion (Misc queries) | |||
Simple algebra and excel | Excel Worksheet Functions | |||
Algebra | Excel Worksheet Functions | |||
how do i write a Algebra formula in excel sheet | Excel Discussion (Misc queries) | |||
Algebra | Excel Worksheet Functions |