Excel Scientific and Engineering Cookbook: Solving Equations

In this paper we're going to focus on solving equations using Excel. Equation solving, in a general sense, can range from finding roots of single equations, to finding values of independent variables that yield a specific value of a dependent variable, to solving systems of nonlinear equations. There are many traditional hand and computerized methods for solving equations. Newton's method for iteratively finding roots of nonlinear equations and Gaussian elimination with back substitution for solving linear systems are just a couple of examples of classical equation-solving methods. Hildebrand's classic book Introduction to Numerical Analysis presents several classical methods for equation solving. The Numerical Recipes books also present algorithms in a variety of programming languages suitable for equation solving.