Goal Seek

J

jon

Hi,

Having problems with Goalseek in VBA. My target value is
one, but it only seems to target it within 4 decimal
places (e.g. stops at 0.9996) but i need an exact number.
it returns a solution which is 18 decimal places, but it
doesn't go to the same for the target.

any ideas?
 
J

Jim Rech

Goal Seek seems to have a limit on the number of iterations it uses and/or a
point when it says "close enough". There is nothing you can do about that,
as far as I know.

MS suggests that you use the Solver add-in if you want more control.

--
Jim Rech
Excel MVP
| Hi,
|
| Having problems with Goalseek in VBA. My target value is
| one, but it only seems to target it within 4 decimal
| places (e.g. stops at 0.9996) but i need an exact number.
| it returns a solution which is 18 decimal places, but it
| doesn't go to the same for the target.
|
| any ideas?
 
Top