Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello!
Here is a link to a file with my situation: http://www.savefile.com/files/8301241 I need to find a way to set up a spreadsheet where I can input the variables G, H, W, J, Q, S and have excel calculate the possible answers that satisfy all of the equations in column D. I know to do this on paper you use matrix algebra but I have no clue how to do this in excel. Column B is the results I should be getting for each variable in column A (with the input values in column F) but I can't get it to work in excel. Column C is a quick attempt I made to use iterate and circular references but to no avail. If anyone can point me in the right direction I would REALLY appreciate it. Oh and column A is a list of all variables used in the equations in column D. Is it even possible to input values for the variables in column E and have excel use those to find answers that satisfy all of the equations in column D?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
[newbie] solving algebra in excel | Excel Discussion (Misc queries) | |||
algebra by excel | Excel Worksheet Functions | |||
Algebra in Excel | Excel Discussion (Misc queries) | |||
Simple algebra and excel | Excel Worksheet Functions | |||
how do i write a Algebra formula in excel sheet | Excel Discussion (Misc queries) |