Excel is looping to the maximum amount of iterations when I do goal seek for a fairly simple calculation?

mstamford

New Member
Joined
Mar 12, 2021
Messages
1
Office Version
  1. 365
Platform
  1. Windows
Hi - I am having an issue with the goal seek function.

I am trying to set the difference between two values to 0 and use goal seek to do this. However, one of the requirements for this model I am working on is that one of the values has to be greater than or equal to the other. But, when I change one of the inputs to be within the same integer (ie. one value is 10.45, and I set the other to be 10.9), it loops to the maximum number of iterations before not returning a solution. I know the model itself works, because if I set 10.9 to be 11.0, it returns a solution. Can anyone provide any insight into this issue?

Also, I am using goal seek through a macro for my sheet, not sure if that matters. Because when I step through the goal seek feature, I have the same issue.

Thanks!
 

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Forum statistics

Threads
1,226,116
Messages
6,189,057
Members
453,524
Latest member
AshJames

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top