Alter a percentage follow up
Alter a percentage follow up
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Alter a percentage follow up

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    465
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I just realized that I can alter a number (with a formula) by using "Goal Seek', but the only drawback is that it can only be done one cell at a time. Any way around that?

    Thanks

    Anthony

  2. #2
    MrExcel MVP Damon Ostrander's Avatar
    Join Date
    Feb 2002
    Location
    Denver, Colorado USA
    Posts
    4,240
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Anthony,

    I assume when you referred to only allowing one cell at a time you were referring to the input cell (the dependent variable), but that you want Solver to be able to handle multiple input variables. Actually you can do this by giving Solver an input Range of cells (e.g., B4:B7), and Solver will modify them in such a way as to produce the optimum value you are seeking. See in the Excel helps the topic:

    Guidelines for designing a model to find values with Solver

    This is a VERY powerful feature, and one that is not widely recognized.
    Keep Excelling.

    Damon

    VBAexpert Excel Consulting
    LinkedIn Profile http://www.linkedin.com/pub/damon-ostrander/7/79/a93
    AllExperts Profile http://www.allexperts.com/ep/1059-30...-Ostrander.htm

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    465
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Thanks Damon!!!!!!! I'll give it a try!

    Anthony

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com