## Method 1 – Use of Solver Feature

**Enable Solver Feature**

- Go to the
**File**tab.

- Select
**Options**.

- Click on
**Add-ins**and select**Go**.

- Check the
**Solver Add-in**and click**OK**.

- You’ll find the Solver feature under the
**Data**tab.

**Solving the Equation**

- Suppose we have the equation: (Y = 2X + 7), and the Y value is 5.

- In cell
**D5**, enter the formula:

`=2*B5+7`

- Go to the
**Data**tab and click on**Solver**.

- In the
**Solver Parameters**dialog, set the objective to cell**$D$5**with a value of**5**(since Y = 5). - Specify that cell
**$B$5**contains the**X**value. - Uncheck
**Make Unconstrained Variables Non-Negative**. - Click
**Solve**.

- A
**Solver Results**dialog box will open like the image below. - Click
**OK**to**Keep Solver Solution**.

- The solved
**X**value will appear in cell**B5**.

- You can repeat this process for different
**Y**values.

Read More: How to Solve Algebraic Equations with Multiple Variables

## Method 2 – Manual Solution

**Equation Setup**

- In cell
**C6**, enter the equation with the**Y**value inserted.

- Simplify the equation manually and enter the simplified version in cell
**C7**.

**Calculate X**

- In cell
**C8**, enter the formula:

`=(5-7)/2`

- Press
**Enter**to calculate the**X**value.

Read More: How to Solve 2 Equations with 2 Unknowns in Excel

## Things to Remember

- The Solver feature is quicker but automatic.
- Manual solving gives more flexibility but is time-consuming

**Download Practice Workbook**

You can download the practice workbook from here:

## Related Articles

- How to Solve for x in Excel
- How to Solve Polynomial Equation in Excel
- How to Solve System of Equations in Excel
- How to Solve Simultaneous Equations in Excel
- How to Solve Differential Equation in Excel
- How to Solve Exponential Equation in Excel
- How to Solve Cubic Equation in Excel
- How to Solve Colebrook Equation in Excel
- How to Solve Quadratic Equation in Excel VBA

**<< Go Back to Excel Solve Equation | ****Excel Solver Examples | Solver in Excel | Learn Excel**