In this tutorial, you will learn how to solve a system of equations in Excel.
In mathematics, an equation system is a group of two or more equations that share the same set of unknown variables, such as x, y, and z, and for which we must determine the values of the unknown variables in order to solve the equations. We can use functions and the equation solver tool to solve the equation system.
The Excel MMULT and MINVERSE functions can be used to solve a set of equations.
Once ready, we’ll get started by utilizing real-world examples to show you how to solve a system of equations in Excel.
Table of Contents
Solve a System of Equations in Excel
Before we begin we will need a group of data to solve a system of equations in Excel.
Let’s say we want to find the values of x and y for the system of equations shown below:
6x + 3y = 69
4x + 9y = 41
First, you need to have a clean and tidy group of data to work with. We can first enter the following numbers in Excel in order to solve this system of equations.
We can easily solve a system of equation in Excel by using the MMULT and MINVERSE functions. We can insert the following formula =MMULT(MINVERSE(A1:B2),C1:C2).
Once we are done, you will be able to solve a system of equations in Excel. This indicates that the values for x and y are 12 and -1, respectively.