In this video we show how the Evolutionary Solver uses penalties to solve optimization problems using non-smooth functions such as IF and COUNTIF.
These are the two files needed to follow along to this video:
Excel With Wayne is an online Microsoft Excel Training Course taught by Dr. Wayne Winston. Dr. Winston is the world’s foremost Microsoft Excel Expert that teaches at some of the world’s largest organizations including Microsoft and government organizations such as the Navy and Army.
CONTACT INFO
- info@excelwithwayne.com
- 945 McKinney #11488 Houston, TX 77002