# Solver problem

#### roscoe

##### Well-known Member
OK, I can't figure this out. I'm trying to use Solver to determine an input parameter of the BINOMDIST() formula that provides the exact answer I want. It works for some inputs and outputs but not for all.

For example, I want 4 successes out of 7 trials to yield a 95% answer, meaning I need to itterate on the "P" input in the formula [=BINOMDIST(4,7,"P",TRUE) should result in .95]. Using solver it iterates successfully to .3413.

Now, change 4 to 6, and solver drives "P" to an answer that causes a #NUM result (P= 4.023), however I can manually input 0.6518 and I get the right answer.

I've tried adding constraints that won't let the input go outside the bounds of 0 and 1.0 but it does anyway.

Ideas?

### Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

#### Fazza

##### MrExcel MVP
Hi Roscoe,

How about as an alternative, using the goal seek fucntion?

I tried it just now, had problems like you with the solver but success with goal seek.

HTH. Regards, Fazza

#### c_m

##### Well-known Member
Yup, same here...so how come goalseek works and solver doesnt?

#### Fazza

##### MrExcel MVP
Yup, same here...so how come goalseek works and solver doesnt?
I am not familiar enough with either to comment authoritavely: I guess the algorithms are quite different.

#### roscoe

##### Well-known Member

I ended up building two versions using the same inputs. I press one macro button to use Goal seek and another to use Solver. Solver gives more accurate answers, but Goal Seek is more likely to converge. Very odd and very annoying.

I'm just glad it's not me!

#### Fazza

##### MrExcel MVP
What about using the goal seek for a first pass and then feed this - as a starting point - into the solver?

And again, it will depend on the algorithm and I guess the settings/criteria for solver. Usually for these sort of solver routines the starting point can make a big difference, and sometimes in unexpected ways...

#### roscoe

##### Well-known Member

Nope. Putting in the exact correct value still results in a divergent solution. Makes absolutely no sense whatsoever.

#### Fazza

##### MrExcel MVP
Well, it is often the way with this sort of thing.

Thanks anyway.

#### Fazza

##### MrExcel MVP

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,164,382
Messages
5,836,931
Members
430,463
Latest member
mikmob

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back