Introduction: How to Solve Logic Puzzles With Microsoft Excel
You have most likely seen this type of puzzle pop across your online feed. Some are simple enough that you can figure them out in your head. However, as the number of equations increases, the challenge becomes harder. This short tutorial shows you an easy way to solve this type of puzzle using Microsoft Excel. Note that these instructions are for MS Office 2016 but the same logic applies to newer versions of Excel.
Step 1: Solver Add In
Add-ins provide optional commands and features for Microsoft Excel. By default, add-ins are not immediately available in Excel, so you must first install and (in some cases) activate these add-ins so that you can use them.
To enable, do the following:
- Click the File tab, click Options, and then click the Add-Ins category.
- In the Manage box, click Excel Add-ins, and then click Go.
- The Add-Ins dialog box appears.
- In the Add-Ins available box, select the check box next to the add-in that you want to activate. For this exercise, you want to select Solver Add-In. Click OK.
Step 2: Solver Location
Now that you have installed the add-in, you must access it. From the Main Screen, go to the Data tab. The Solver should be included in the Analysis subsection.
Step 3: Setting Up the Problem
Before writing equations, it is often easier to assign variables to the items. This makes it easier when writing the equations. I used the values shown in this image.
Step 4: Adding Data to Excel
Now it's time to enter the data into Excel. Each line from the introduction picture will be added to the spreadsheet. Column E shows the equations in text format. This step isn't needed but I thought it would help with understanding the process. Column F shows the equations in Excel. Column G is the total from each line (see intro picture). Enter data exactly as shown.
Step 5: Solver
You are now ready to net up the solver. Click the Solver icon (Data => Solver) from Step 2. This will bring up a solver panel.
- Start by setting the Set Objective to Cell $F$3. For the To value, set the Value Of to 29. This sets both sides of the equation equal to each other.
- Next, set the By Changing Variable Cells to $D$3:$D$9. This column will fill out during the solving process.
- Click Add
- Repeat the process for the remaining equations as shown.
- You have now filled out all the information required to solve the puzzle.
- To run the solver, click on Solve
Step 6: Give It a Shot
Did it work? Please comment if you have any questions.