如何在Microsoft Excel上求解联立方程 [英] how to solve a simultaneous equation on microsoft Excel

问题描述

我该如何使用Microsoft Excel来求解联立方程

hi ,

how can i use microsoft excel to solve a simultaneous equation

推荐答案

如果我对您的理解正确，那么您可能需要看看以下内容:
在Excel中使用求解器的示例 [

If I understand you correctly you may want to take a look at this:
Example of Using Solver in Excel[^]

copied from the page:
You may want to solve a system of nonlinear equations in your homework. You can do this in a wide variety of ways, but a simple way to find a solution is to use Microsoft Excel''s Solver tool. Be warned that Solver is NOT a very robust tool and may fail to find solutions! In general, finding roots to nonlinear functions is a very difficult problem. Excel does a poor job compared to more powerful programs such as Matlab, but it will suffice for simple problems.

Regards
Espen Harlinn

这篇关于如何在Microsoft Excel上求解联立方程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！