This is the required information we need to solve any sort of equation using Solver Add-in in Excel. Now, launch the Solver Add-in by clicking on the Data tab and click on Solver. STEP 1: Specify ...

Select the variable cells that Solver can adjust, like the hours worked at each job. Add constraints, like making sure no job falls below 4 hours, or that total hours worked equals 40.

With this example, type "A1." Click "Solve." Excel will replace cell A1 with the equation's solution. With this example, it will insert the value "21," the equation's solution, into cell A1.