PRO Courses Hot Guides Tech Help Pro Expert Videos About wikiHow Pro Upgrade
QUIZZES All Quizzes Hot Love Quizzes Personality Quizzes Trivia Quizzes Taylor Swift Quizzes
EDIT Edit this Article
EXPLORE Tech Help ProAbout UsRandom ArticleQuizzes Request a New ArticleCommunity DashboardTrendingForums Arts and EntertainmentArtworkBooksMoviesComputers and ElectronicsComputersPhone SkillsTechnology HacksHealthMen's HealthMental HealthWomen's HealthRelationshipsDatingLoveRelationship Issues Hobbies and CraftsCraftsDrawingGamesEducation & CommunicationCommunication SkillsPersonal DevelopmentStudyingPersonal Care and StyleFashionHair CarePersonal Hygiene Quizzes Love Quizzes Personality Quizzes Fun Games ForumsArts and EntertainmentFinance and BusinessHome and Garden Relationship QuizzesCars & Other VehiclesFood and EntertainingPersonal Care and Style Sports and FitnessComputers and ElectronicsHealthPets and Animals TravelEducation & CommunicationHobbies and CraftsPhilosophy and Religion Work WorldFamily LifeHolidays and TraditionsRelationships Youth
LOG IN
Log in
Social login does not work in incognito and private browsers. Please log in with your username or email to continue. FacebookGooglewikiHow Account No account yet? Create an account
RANDOM
Home
Random
Browse Articles
TrendingNew
Quizzes & Games
All QuizzesHot
Love Quizzes
Personality Quizzes
Fun Games
Dating Simulator
Learn Something New
Forums
Courses
Happiness Hub
Explore More
Support wikiHow
About wikiHow
Log in / Sign up
Terms of Use wikiHow is where trusted research and expert knowledge come together. Learn why people trust wikiHow
Categories
Computers and Electronics
Software
Office
Spreadsheets
Microsoft Excel
How to Use Solver in Microsoft Excel Download Article Written by Jack Lloyd
Last Updated: July 28, 2022 Tested
Download Article
Enabling Solver
|
Analyzing and Solving
|
Video
|
Tips
|
Warnings
|Show more|Show less X
This article was co-authored by wikiHow staff writer, Jack Lloyd. Jack Lloyd is a Technology Writer and Editor for wikiHow. He has over two years of experience writing and editing technology-related articles. He is technology enthusiast and an English teacher. The wikiHow Tech Team also followed the article's instructions and verified that they work. This article has been viewed 648,900 times. Learn more...
This wikiHow teaches you how to use Microsoft Excel's Solver tool, which allows you to alter different variables in a spreadsheet in order to achieve a desired solution. You can use Solver in both Windows and Mac versions of Excel, though you'll have to enable Solver before you can begin using it.
Steps
Part 1 Part 1 of 2:
Enabling Solver
Download Article
1 Open Excel. Click or double-click the Excel app icon, which resembles a green box with a white "X" on it.
Solver comes pre-installed with both Windows and Mac versions of Excel, but you'll have to enable it manually.
2 Click Blank workbook. This will open the Excel window, from which point you can proceed with enabling Solver.
If you have an existing Excel file you'd like to use Solver with, you can open it instead of creating a new file.
Advertisement
3 Click File. It's a tab in the upper-left side of the Excel window.
On a Mac, click Tools instead, then skip the next step.
4 Click Options. You'll find this option at the bottom of the File menu. Doing so brings up the Options window.[1]XResearch source
5 Click Add-ins. It's a tab in the lower-left side of the Options window.
On a Mac, click Excel Add-ins in the Tools menu.
6 Open the "Add-ins Available" window. Make sure that the "Manage" text box has "Excel Add-ins" listed in it, then click Go at the bottom of the page.
On a Mac, this window will open after clicking Excel Add-ins in the Tools menu.
7 Install the Solver add-in. Check the "Solver" box in the middle of the page, then click OK. Solver should now appear as a tool in the Data tab that's at the top of Excel.
Advertisement Part 2 Part 2 of 2:
Analyzing and Solving
Download Article
1 Understand Solver's use. Solver can analyze your spreadsheet's data and any constraints you've added to show you possible solutions. This is useful if you're working with multiple variables.
2 Add your data to your spreadsheet. In order to use Solver, your spreadsheet must have data with different variables and a solution.
For example, you might create a spreadsheet documenting your various expenses over the course of a month with the output cell resulting in your money left over.
You can't use solver on a spreadsheet which doesn't have solvable data (i.e., your data has to have equations).
3 Click the Data tab. It's at the top of the Excel window. This will open the Data toolbar.
4 Click Solver. You'll find this option in the far-right side of the Data toolbar. Doing so opens the Solver window.
5 Select your target cell. Click the cell in which you want to display your Solver solution. This will add it to the "Set Objective" box.
For example, if you're creating a budget where the end goal is your monthly income, you would click the final "Income" cell.
6 Set a goal. Check the "Value Of" box, then type your target value into the text box next to "Value Of".
For example, if your goal is to have $200 at the end of the month, you would type 200 into the text box.
You can also check either the "Max" or "Min" box in order to prompt Solver to determine the absolute maximum or minimum value.
Once you've set a goal, Solver will attempt to meet that goal by adjusting other variables in your spreadsheet.
7 Add constraints. Constraints set restrictions on the values that Solver can use, which prevents Solver from accidentally nullifying one or more of your spreadsheet's values. You can add a constraint by doing the following:[2]XResearch source
Click Add
Click the cell (or select the cells) for which the constraint applies.
Select a type of constraint from the middle drop-down menu.
Enter the constraint's number (e.g., a maximum or minimum).
Click OK
8 Run Solver. Once you've added all of your constraints, click Solve at the bottom of the Solver window. This will prompt Solver to find the optimal solution for your problem.
9 Review the results. When Solver alerts you that it has an answer, you can see the answer by looking at your spreadsheet to see which values were changed.
10 Change your Solver criteria. If the output that you received isn't ideal for your spreadsheet, click Cancel in the pop-up window, then adjust your objective and constraints.
If you do like your Solver's results, you can apply them to your spreadsheet by checking the "Keep Solver Solution" box and then clicking OK.
Advertisement
Expert Q&A
Search Add New Question Ask a Question 200 characters left Include your email address to get a message when this question is answered. Submit Advertisement
Video
Tips
Solver is best used for problems such as scheduling employees, determining the lowest price for which you can sell items while meeting a financial goal, and budgeting. Thanks Helpful 2 Not Helpful 0
Submit a Tip All tip submissions are carefully reviewed before being published Name Please provide your name and last initial Submit Thanks for submitting a tip for review! Advertisement
Warnings
Solver cannot be used in spreadsheets in which there is no "output" or actual solution. For example, you can't apply solver to a spreadsheet which has no equations. Thanks Helpful 1 Not Helpful 2
Advertisement
You Might Also Like
How toCreate a Budget SpreadsheetHow toMake a Spreadsheet in ExcelHow toApply Conditional Formatting in ExcelHow toSubtract in ExcelHow to Use VLOOKUP with an Excel SpreadsheetHow to Add Numbers & Cells in Excel: Complete GuideHow to Create a Break Even Chart in Excel for Your Business ExpensesHow toTrack your Bills in Microsoft ExcelHow to Use the SUM Function in Excel to Add Cells, Ranges, & NumbersHow toMake a Personal Budget on ExcelHow to Run a Multiple Regression in Microsoft Excel: Step-by-Step GuideHow to Add Up Columns in Microsoft Excel: Quickly Sum Numbers3 Simple Ways to Edit Data in MS ExcelExcel Macros: How to Run, Record, and Use Macros in Excel Advertisement
Written by: Jack Lloyd wikiHow Technology Writer This article was co-authored by wikiHow staff writer, Jack Lloyd. Jack Lloyd is a Technology Writer and Editor for wikiHow. He has over two years of experience writing and editing technology-related articles. He is technology enthusiast and an English teacher. This article has been viewed 648,900 times. How helpful is this? Co-authors: 25Updated: July 28, 2022 Views: 648,900 Categories: Microsoft ExcelArticle SummaryX
1. Enable Solver in the "Add-ins" section of your Excel preferences if necessary. 2. Open a spreadsheet with data you want to analyze. 3. Click Data, then click Solver. 4. Select a cell to use from the "Set Objective" field. 5. Check the "Value Of" box, then enter a desired value. 6. Click Solve. Did this summary help you?YesNo
In other languages Spanish German Russian Indonesian Dutch Italian Japanese
Print
Send fan mail to authors
Thanks to all authors for creating a page that has been read 648,900 times.
Is this article up to date?
Yes No Advertisement Cookies make wikiHow better. By continuing to use our site, you agree to our cookie policy. Written by: Jack Lloyd wikiHow Technology Writer Click a star to vote Co-authors: 25Updated: July 28, 2022 Views: 648,900
Quizzes & Games
IQ TestTake QuizAm I Smart QuizTake QuizHow Rich Will I Be QuizTake QuizCognitive TestTake QuizWhat Is My Work Style QuizTake QuizAdvanced Roulette GamePlay
You Might Also Like
How toCreate a Budget SpreadsheetHow toMake a Spreadsheet in ExcelHow toApply Conditional Formatting in ExcelHow toSubtract in Excel
Featured Articles
Hilarious Clean Jokes That’ll Make Adults & Kids LaughAm I Ready For A Relationship QuizWhy Is He Ignoring Me? 12 Possible Reasons (Plus, What to Do)A Complete Style Guide for the Gamine Kibbe Body TypeHow to Tell if You’re in LoveWhich Chaotic Evil Villain Am I Quiz
Trending Articles
Let Us Rate You 1-10: Attractiveness Scale QuizCan We Guess If You're Single or Taken?How toMake OutAm I a Gigachad or Totally Chopped?How Rare Is My Birthday QuizHow Nonchalant Am I Quiz
Featured Articles
What Does It Mean If Someone Tries to Kill You in Your Dream?200+ Best Questions to Ask Someone You Like (Texting & IRL)How Beautiful Am I Quiz13 Types of Hairlines for Men and Women (And How to Maintain Yours)Which of the 8 Face Shapes Do You Have? Helpful Tips & Style GuidanceMental Illness Test
Featured Articles
How toEnjoy the HolidaysHow to Get 250 Grams of Protein Daily: Best Foods, Meal Plans & MoreAm I Girly Quiz200 Fun, Flirty, & Deep Questions to Get to Know a Guy BetterHow to Tighten Skin Under Your Chin: Natural or Surgical OptionsWhat Would My Nickname Be Quiz
Watch Articles
How toWrap a Round GiftHow toSteam in an OvenHow to Make Plant-Based Meat: 4 Incredible RecipesHow toClean a Silver Necklace4 Easy Ways to Open a Can of SodaHow toPart Your Hair
Trending Articles
180 Good Comebacks & Savage Roasts to Win Any ArgumentAm I a Furry QuizHave I Met My Soulmate Yet QuizRandom Fortune GeneratorWhat Should My Name Really Be QuizWhat Are the Gay Male Body Types (And Which Do You Have?)
Quizzes & Games
The Impossible QuizTake QuizJob Simulator: Office WorkerPlayWhat Do I Want in a Weight Loss Program QuizTake QuizHow You Can Discover HappinessTake QuizDo You Have What It Takes To Become A Millionaire?Take QuizWhat Kind of Vacation Should You Go On?Generate
Categories
Computers and Electronics
Software
Office
Spreadsheets
Microsoft Excel
wikiHow Newsletter You're all set! Helpful how-tos delivered toyour inbox every week! Sign me up! By signing up you are agreeing to receive emails according to our privacy policy.
Home
About wikiHow
Experts
Jobs
Contact Us
Site Map
Terms of Use
Privacy Policy
Do Not Sell or Share My Info
Not Selling Info
Contribute
Follow Us
×
wikiHow Tech Help:
Tech troubles got you down? We've got the tips you need
Download Article Written by Jack Lloyd 
Advertisement 
Written by: Jack Lloyd wikiHow Technology Writer This article was co-authored by wikiHow staff writer, Jack Lloyd. Jack Lloyd is a Technology Writer and Editor for wikiHow. He has over two years of experience writing and editing technology-related articles. He is technology enthusiast and an English teacher. This article has been viewed 648,900 times. How helpful is this? Co-authors: 25 Updated: July 28, 2022 Views: 648,900 Categories: Microsoft Excel Article SummaryX
Take Quiz
Take Quiz
Take Quiz
Take Quiz
Take Quiz
Play 
Take Quiz
Play
Take Quiz
Take Quiz
Take Quiz
Generate 
625 
1 Open Excel. Click or double-click the Excel app icon, which resembles a green box with a white "X" on it. 
2 Click Blank workbook. This will open the Excel window, from which point you can proceed with enabling Solver. 
3 Click File. It's a tab in the upper-left side of the Excel window. 
4 Click Options. You'll find this option at the bottom of the File menu. Doing so brings up the Options window.[1] 
5 Click Add-ins. It's a tab in the lower-left side of the Options window. 
6 Open the "Add-ins Available" window. Make sure that the "Manage" text box has "Excel Add-ins" listed in it, then click Go at the bottom of the page. 
7 Install the Solver add-in. Check the "Solver" box in the middle of the page, then click OK. Solver should now appear as a tool in the Data tab that's at the top of Excel. Advertisement 
1 Understand Solver's use. Solver can analyze your spreadsheet's data and any constraints you've added to show you possible solutions. This is useful if you're working with multiple variables. 
2 Add your data to your spreadsheet. In order to use Solver, your spreadsheet must have data with different variables and a solution. 
3 Click the Data tab. It's at the top of the Excel window. This will open the Data toolbar. 
4 Click Solver. You'll find this option in the far-right side of the Data toolbar. Doing so opens the Solver window. 
5 Select your target cell. Click the cell in which you want to display your Solver solution. This will add it to the "Set Objective" box. 
6 Set a goal. Check the "Value Of" box, then type your target value into the text box next to "Value Of". 
7 Add constraints. Constraints set restrictions on the values that Solver can use, which prevents Solver from accidentally nullifying one or more of your spreadsheet's values. You can add a constraint by doing the following:[2] 
8 Run Solver. Once you've added all of your constraints, click Solve at the bottom of the Solver window. This will prompt Solver to find the optimal solution for your problem. 
9 Review the results. When Solver alerts you that it has an answer, you can see the answer by looking at your spreadsheet to see which values were changed. 
10 Change your Solver criteria. If the output that you received isn't ideal for your spreadsheet, click Cancel in the pop-up window, then adjust your objective and constraints.