Add-ins.com home page
Questions? E-mail us or call us 302-234-9857, 8AM to 10PM U.S. East Coast Time 7 days a week
       

View Cart

US $29.95

Add to shopping cart

Quantity
Discounts

Order online
Immediate
download

Money back
guarantee

Multi-Cell Goal Seeker
An add-in product for Microsoft Excel

  • Do multiple goal seeks at one time
  • Goal seek cells to different values
  • Menu driven
  • Help and exercise file to help you learn to use

Download a trial version now!

   

Screen shots:

The Multi-Cell Goal Seeker add-in for Microsoft Excel allows you to get goal seek solutions to many spreadsheet cells at one time by automating the goal seek function.  It is compatible with Microsoft Excel 2003, Excel 2007, Excel 2010, Excel 2013 and Office 365.

The Multi-Cell Goal Seeker does multiple goal seeks automatically - eliminate manually processing multiple goal seek solutions.  It is menu driven for ease of use.

For example, assume your spreadsheet looks like the following:

You need to set the monthly ending inventory (the yellow cells) to 500 units by varying the production (the blue and bold cells).  

With the Multi-Cell goal Seeker, you would first be prompted for the cells to be set: (all the yellow cells B16:G16).  Then you would be prompted for the desired value in this case 500.  If you wanted to you could specify cells containing individual target values by month.

Lastly you are prompted for the first cell in the range of cells that can be changed in order to achieve the goal values.  This would be B12 which will be adjusted by the Goal Seeker to achieve 500 for cell B16.  The Multi-Cell Goal Seeker would then modify C12 to achieve 500 for C12 and so forth.

When the goal seeking is completed the results look like the following:

 

 

Order online from our secure service.
Get delivery in minutes!

Add to shopping cart

  US $29.95



Customers who viewed the Multi-Cell Goal Seeker also viewed:.


Copyright 2013 Add-ins.com LLC, all rights reserved.  Spreadsheet Assistant is a registered trademark of Add-ins.com LLC.