Video Tutorial: Using Excel Solver for Nonlinear Equations

Trying to figure out how to get Excel to solve multiple nonlinear equations at once? In this video tutorial from Learn ChemE, you'll see a demonstration that uses Excel Solver to handle three equations simultaneously. In specific, you'll see two nonlinear equations solved in a dew point calculation for Raoult's Law using Solver. 

If you're looking for other tips for Excel, consider checking out our popular series Excel Tips for Chemical Engineers. If you're looking for more in-depth instruction, check out AIChE’s virtual combo course on spreadsheet problem solving and VBA programming. It’s taught by David E. Clough, the author of the blog series, and combines two of AIChE’s most popular spreadsheet courses, Spreadsheet Problem-Solving for Chemical Engineers and Excel VBA Programming for Chemical Engineers. 

Need help with another chemical engineering topic? Take a moment to look at the many short tutorials available from the Learn ChemE playlists. Or if you're looking for greater depth and detail, check out some of AIChE's Academy courses, including a large number that are free.