EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Tools Solve Equation in Excel
Secondary Sidebar
Excel Functions
  • Excel Tools
    • Excel Shortcut Redo
    • Reduce Excel File Size
    • Quick Analysis in Excel
    • Goal Seek in Excel
    • Compare Two Lists in Excel
    • Excel Quick Analysis
    • Estimate Template in Excel
    • Pivot Table Count Unique
    • CSV Files into Excel
    • Excel Business Plan Template
    • Excel Export to PDF
    • Free Excel Template
    • Excel Repair
    • Color in Excel
    • Form Controls in Excel
    • Timecard Template in Excel
    • How to Unhide All Sheets in Excel?
    • Power Query in Excel
    • Power View in Excel
    • XML in Excel
    • Excel Evaluate Formula
    • Examples of Excel Macros
    • Consolidation in Excel
    • Ribbon in Excel
    • Excel Conditional Formatting for Dates
    • Protect Sheet in Excel
    • Data Model in Excel
    • Pivot Table Examples
    • Pivot Table Slicer
    • Pivot Table Filter
    • Watch Window in Excel
    • Slicer in Excel
    • Print Gridlines in Excel
    • Convert Numbers to Text in Excel
    • Freeze Columns in Excel
    • Spelling Check in Excel
    • Name Box in Excel
    • Solve Equation in Excel
    • Excel Spreadsheet Examples
    • What If Analysis in Excel
    • How to Print Labels From Excel
    • Excel Named Range
    • Excel TRANSPOSE Formula
    • Excel Merge and Center
    • Excel Freeze Rows
    • HLOOKUP Formula in Excel
    • Excel Create Database
    • Excel Gridlines
    • Excel Spreadsheet Formulas
    • Excel Sort By Number
    • Excel Concatenating Columns
    • Excel AutoCorrect
    • Conditional Formatting For Blank Cells
    • Excel Icon Sets
    • Excel CTRL D
    • Excel Accounting Number Format
    • Excel Regression Analysis
    • Excel Import Data
    • Excel Freeze Panes
    • Excel Calendar
    • Excel Developer Tab
    • Excel Enable Macros
    • Excel Autosave
    • Heat Map in Excel
    • Excel Toolbar
    • Excel Error Bar
    • Excel Status Bar
    • Excel Unprotect Sheet
    • Check mark in Excel
    • Excel Column Filter
    • Excel Header and Footer
    • Excel Drawing
    • Range in Excel
    • Timeline in Excel
    • Excel Lock Formula
    • Excel Table styles
    • Insert New Worksheet in Excel
    • Excel Column Lock
    • Excel Forms for Data Entry
    • QUOTIENT in Excel
    • Excel Sorting
    • Excel Sort by color
    • Excel Data Bars
    • Excel Tool for Data Analysis
    • Excel Flash Fill
    • Excel Auto Fill
    • Excel Quick Access Toolbar
    • Excel Wrap Text
    • Excel Exponential Smoothing
    • Excel ANOVA
    • Excel Merge Two Tables
    • Excel Conditional Formatting in Pivot Table
    • Dynamic Tables in Excel
    • Excel Sort by date
    • Excel Dynamic Range
    • Record Macro in Excel
    • Two Variable Data Table in Excel
    • Merge Cells in Excel
    • One Variable Data Table in Excel
    • Excel Fill Handle
    • CheckBox in Excel
    • Excel Table
    • Excel Combo Box
    • Auto Format in Excel
    • Advanced Filter in Excel
    • Excel AutoFilter
    • Excel Data Filter
    • Excel Data Validation
    • Excel Radio Button
    • Data Table in Excel
    • Text to Columns in Excel
    • Excel List box
    • Excel Solver Tool
    • Scrollbar in Excel
  • Excel Functions (12+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED Training
  • EXCEL Training COURSE

Solve Equation in Excel

By Pradeep SPradeep S

solve equation in excel

Solve Equation in Excel (Table of Contents)

  • Overview of Solve Equation in Excel
  • How to Add the Solver Add-in Tool?
  • Example on How to Solve Equations Using Solver Add-in Tool

Overview of Solve Equation in Excel

Excel help’s us out in many ways by making the task easier & simple. Solver Add-in tool is significant to perform or solve equations in excel. Sometimes we need to perform or carry out reverse calculations, where we need to calculate one or two variables to get the desired end results.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

Example: For the profit of the extra 10%, how many units need to be sold or what is the exact marks needed in the last semester of final exams to get the distinction.

This above calculation or equations can be calculated with the help of Solver Add-in, with specific criteria.

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,368 ratings)

Definition of Solve Equation in Excel

It is used to determine the optimal value of the target cell by changing values in cells used to calculate the target cell.

It contains the below-mentioned parameters.

  • Target
  • Variables
  • Constraints
  • Formula to use to calculate

How to Add the Solver Add-in Tool?

Let’s check out how to add the solver add-in tool in excel. Calculation or equations can be calculated with the help of Solver Add-in, with specific criteria.

To add the Solver Add-in tool, the below-mentioned procedure is followed:

  • Click on the File option or an Office Button; then, you need to click on Excel Options.

how to add solver add-in tool 1

  • Now, the Excel Options window dialog box appears; under Add-ins, select Solver Add-in in the inactive application add-ins list and “Go.”

how to add solver add-in tool 2

  • Add-ins window appears where you can see the list of active add-ins options. Tick the Solver Add-in and click on the “Ok” button.

how to add solver add-in tool 3

Now, you can observe, Solver Add-in got added to the Excel sheet as Solver under the “Data” tab on the extreme right side.

how to add solver add-in tool 4

Example on How to Solve Equations Using Solver Add-in Tool

To calculate Variable Values For % Profit Maximization with the help of the Solver Add-in Tool.

You can download this Solve Equation Excel Template here – Solve Equation Excel Template

solve equation in excel example 1.1

In the above-mentioned table, the monthly sales data of price per unit, containing Cost or stockiest Price per unit & Selling Price per unit to customers. Now, I have April & May month with a percentage profit for each unit, i.e. 13.33% & 15.38% respectively.

Here, B4 & C4 is the percentage profit for the month of April & May 2019, which is calculated with the help of the below-mentioned formula.

Formula to Find out Percentage Profit: 

((Selling price per unit – Stockist price per unit)/ Stockist price per unit) *100

Variables (B2, B3 & C2, C3): Here, variables are Cost or stockiest Price per unit & Selling Price per unit to customers, which keeps on changing month on month.

Target & Constraints

Now, my target is to take the percentage profit (%) per unit to 20%. So, for that, I need to find out the Cost or stockiest Price per unit & Selling Price per unit to customers needed to achieve a profit of 20%.

  • Target Cell: D4 (Profit %) should give a 20% profit
  • Variable Cells: C2 (Cost or stockiest Price per unit) and C3 (Selling Price per unit to customers)
  • Constraints: D2 should be >= 16,000 and D3 should be <= 20,000

Formula to Find out Percentage Profit: 

((Selling price per unit – Stockist price per unit)/ Stockist price per unit) *100

i.e. ((D3-D2)/D2) *100

Prior to usage of the solver add-in tool, we need to enter the profit calculator formula ((D3-D2)/D2) *100 in the target cell (D4) to calculate the 20 % profit.

solve equation in excel example 1.2

It is the significant information which is required to solve any sort of equation using Solver Add-in in Excel. Now, select a cell D4, and I need to launch the Solver Add-in by clicking on the Data tab and select a Solver.

solve equation in excel example 1.3

Once solver is selected, Solver parameter window appears, where you need to mention the “Target Cell” as “D4” cell reference in the set objective text box and select a radio button as “Value of”, In the text box of it set the targeted profit as 20 %

solve equation in excel example 1.4

solve equation in excel example 1.5

In the “By changing variable cells”, select the range of D2 (Cost or stockiest Price per unit) and D3 (Selling Price per unit to customers) cell where it is mentioned as $D$2:$D$3 in the text box.

solve equation in excel example 1.6

After the addition of changing variable cell range, we need to add constraints; it is added by clicking on add under the subject to the constraints.

solve equation in excel example 1.7

Now, the first parameter of Constraints is added by inputting the cell reference & constraint value, i.e. Cost price or stockiest Price per unit, which is either more than or equal to 16,000 (>=16000)

solve equation in excel example 1.8

solve equation in excel example 1.9

Now it gets reflected under Subject to the Constraints box, again we need to click on add to add one more constraint, i.e. Selling Price per unit to customers, it is added by inputting the cell reference & constraint value, which is either less than or equal to 20,000 (<=20000)

solve equation in excel example 1.10

SEE example 1.11

Now, we added all the parameters; just we need to click on solve.

SEE example 1.12

It will ask whether you want to keep the solver solution along with original values; you can Select these options based on your requirement; here, in this scenario, I have selected Keep Solver Solution and click on the “Ok” button.

SEE example 1.11

Now, you will observe a change in the value in the cell D2 (Cost or stockiest Price per unit) and D3 (Selling Price per unit to customers) to 16000 and 19200 respectively to get the 20% Profit.

SEE example 1.13

Things to Remember About Solve Equation in Excel

Most of the third party excel add-in program is available, that provides to solve equations & data analysis tools for statistical, financial and engineering data and Other tools & function which are used to solve equations in excel are:

  • What-If Analysis: It is also used to solve equations & data analysis, wherein it allows you to try out different values (scenarios) for formulas to get the desired output.
  • Goal Seek: It is an inbuilt function in excel under What-If Analysis, which helps us solve equations to source cell values until the desired output is achieved.

Recommended Articles

This is a guide to Solve Equation in Excel. Here we discuss how to add the Solver Add-in Tool and how to Solve equations with Solver Add-in Tool in excel. You can also go through our other suggested articles to learn more –

  1. Evaluate Formula in Excel
  2. Excel Solver Tool
  3. VBA Solver
  4. Standard Deviation in Excel
Popular Course in this category
MS Excel Training Bundle
  13 Online Courses |  100+ Hours |  Verifiable Certificates |  Lifetime Validity
4.5
Price

View Course

Related Courses

Excel Advanced Training (16 Courses, 23+ Projects)4.9
Excel Training (23 Courses, 9+ Projects)4.8
1 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Solve Equation Excel Template

EDUCBA

Download Solve Equation Excel Template

EDUCBA

डाउनलोड Solve Equation Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more