Use the Solver Add-in for Excel to Produce a Specific Formula Result
This is Part 2 of my series of videos demonstrating how to use the SOLVER Add-in for Excel. Remember that SOLVER is not activated by default. I show you how to activate it in Part 1 of this series.
Here, I want SOLVER to automatically change the Units Sold so that the resulting Gross Profit Sales are $25,000.
This is similar to the way that I used SOLVER in Part 1. What is different? I, first, used the SUMPRODUCT Function to determine what would be a "reasonable target" for SOLVER to produce. Even though SOLVER is a very powerful tool to use to produce Business Intelligence Reports, you must use your own intelligence - and understanding of your business - to make the proper decisions.
I invite you to visit my online shopping website - http://shop.thecompanyrocks.com - to view all of my videos and to take advantage of the many resources that I offer you.
Danny Rocks
The Company Rocks