# Solver Excel Example - An easy to understand example

Excel 2007 Excel 2003 Macros Excel 2007 Macros Excel 2003 Excel 2010

Hello and welcome to the familycomputerclub.com!
I've received many emails lately about how to use solver in Excel. Let's take an example of a training institute. Depending on the number of students per month and the average fees that it charges, we can calculate the annual income. Similarly we can compute the annual expenses. Now the annual profit before taxes and depreciation will be equal to the income minus the expenses. The institute owner is not happy. He wishes his income to be 1000000. To do that he has to get more students and/or decrease his expenses. Of course, he cannot have unlimited number of students and he cannot reduce his expenses to zero. So he has to work within certain constraints. Using these details we can ask solver to provide a solution.
So our target cell is the profit in cell b3.
Our profit dpends on the number of students in cells e3 to e14. They cannot be unlimited and they cannot be fractions. Our profit also depends on the fees that we charge and we cannot charge what we like but as per market conditions. The average fee is in cells F3 to F15.
Our profit also depend on how we control our expenses. Here also we face constraints. So we can reduce our expenses only upto to a certain extent.
Therefore we need to provide Solver with some constraints so that it can help us to find a good solution.
Now let's see how we can solve the problem and learn how to use the basics of Solver in Excel.
• Click on data tab and from the Analysis area we then select Solver
• In the dialog box our target cell is B3 which represents the profit. We wish to set it to 10000000. If we set it to 0 we can calculate the breakeven.
• In the changing cells we select the average fees (F15), K3:K14 represents the total monthly expenses, E3:E14 represents the number of students and J3:J14 represents the other expenses which forms the part of the total expenses. Now these cells are related to the income and expenses which when changed influence the amount of profit made.
• Finally we add our constraints. For example our students cannot be fractions and therefore they are defined as integers. Our other expenses cannot be less than 13500 but also not more than 15000 and so on.
• Finally we click on "Solve' to learn whether Solver finds a solution.

Watch the video below tp learn about the feature (about 36 MB):

More Tips (Solutions):
How do I view and edit Microsoft Excel files on an iPad?
Inventory Soluton
How to rename and color worksheet tabs
Copy Worksheet Quickly
Criteria Range
Animations in Microsoft Excel
Create two charts at once
How to avoid errors while working in Excel
How to benefit from Microsoft Excel Templates
How to use Microsoft Excel 2007 with Word 2007 - create mail merge labels
Landscape Oriented Worksheet Template
How to-make a worksheet fit a printed page
How to make your charts more impressive
Perpetual Calendar from 1900 to 9999
How to create your own custom add-in
How to clear  conditional formattng  in Excel worksheets
How to speed up data entry of decimal numbers
How to change the color of the gridlines of an Excel worksheet or hide them
How to use Autosum in Multiple Worksheet Cells Quickly
How to have your free personal assistant in Mcrosoft Excel who reads out the data to you
How to use the status bar in Microsoft Excel to do a quick data analysis
How to calculate equal monthly payments or instalments using a mathematical equation
Data Forms to Enter and Edit Data
View 2 worksheets in same workbook side by side
Accessing a specific worksheet in large workbooks with multiple worksheets
Referencing a cell in another worksheet
How to perform a what-if analysis using a scrollbar form control
An interesting payroll solution
Future Value Solution in Microsoft Excel
Another Interesting Conditional Formatting Solution
DSUM and Array Formulas for addition solutions
IF Function Question
How to use command buttons on a splash screen in MS-Excel
Copy Paste Data from one Excel Worksheet to Another
How to separate comma separated values (csv) in a worksheet cell in Microsoft Excel into rows or columns
Another Interesting Solver solution in Microsoft Excel
Find duplicates in two different Excel worksheets using a macro
How to count data based on multiple criteria - countifs function
How to convert 6/5/2011 into Sunday, 6/5/2011
User Form to perform calculations
An interesting solution using conditional formatting in Microsoft Excel 2007
Show/Hide Controls on a User-Form using a Checkbox
Populate Listbox and Textboxes with Excel data using VBA and Vlookup
Protecting Specific Worksheets in an Excel Workbook using VBA
How to calculate the difference in hours between two date-time values
How do I match data from 2 worksheets and highlight the differences using MS-Excel VBA?
How to focus on a specific control (TextBox1) on a user-form in MS-Excel
Interesting sumproduct solution
COMPARE DATA LISTS USING VLOOKUP AND ISNA FUNCTIONS
VLOOKUP SOLUTION USING LIST IN MS EXCEL
How to generate random numbers in MS Excel
Lottery game in Microsoft Excel
Nested If Function to Determine Project Complexity
Power Billing Solution in Microsoft Excel

Excel 2007 Excel 2003 Macros Excel 2007 Macros Excel 2003 Excel 2010