In Today's Post I will share with you a simple function that can be of tremendous help to you if you want to solve System of 3 Linear Equation. Such a System of Linear Equation is often represented like below:
It might not be difficult to solve this if you have any high-end calculator for Texas or Casio or HP but in case you don't have one, you can use this sheet that i have setup. Here is a glance of how does this work:
Here i have added the co-efficient and the constant of the equation that facilitate the working of the excel function MDETERM(), since the function does not accept discontinuous ranges, we have to accommodate the sheet to overcome this hurdle.
I am not going to add the manual workout of the problem but a snap shot of how this file save time:
you can see all done by just entering the data in few cells, rest is up-to the built-in function of excel 2007. Download this sheet and play with it..
It might not be difficult to solve this if you have any high-end calculator for Texas or Casio or HP but in case you don't have one, you can use this sheet that i have setup. Here is a glance of how does this work:
Here i have added the co-efficient and the constant of the equation that facilitate the working of the excel function MDETERM(), since the function does not accept discontinuous ranges, we have to accommodate the sheet to overcome this hurdle.
I am not going to add the manual workout of the problem but a snap shot of how this file save time:
No comments:
Post a Comment