Goal Seek

  • Thread starter Thread starter jon
  • Start date Start date
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?
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with Goalseek Macro 5
Macro for copy and paste values 3
Parameter Input for Goal Seek 2
macro Help 3
Debug problem 3
Goal seek - column reference 3
goal seek wont calculate an accurate value past 3 decimal places 1
vba goal seek 2 1

Back
Top