O'Reilly logo

Microsoft® Office Excel® 2003 Step by Step by Curtis Frye

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Finding Optimal Solutions with Solver

Finding Optimal Solutions with Solver

GoalSeek is a great tool for finding out how much you need to change a single input to generate a desired result from a formula, but it’s of no help if you want to find the best mix of several inputs. For example, Catherine Turner might want to advertise in four regional magazines to drive customers to The Garden Company’s Web site, but she might not know the best mix of ads to place among the publications. She asked the publishers for ad pricing and readership numbers, which are reflected in the spreadsheet shown below, along with the minimum number of ads per publication (three) and the minimum number of times ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required