Elliottgpjones
New Member
- Joined
- Apr 29, 2022
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hi all - i am running a simple automated goal-seek in order to find what the price of a product has to be in order to return a 10% IRR for a project. it works fine, however if i change some of my inputs by too large-an increment, it seems to fail as the IRR function shows "#NUM". For example, changing my cost input from 50 to 25 works fine, but then changing it back up to 50 results in an error message. Could someone kindly help with this?
Furthermore, i am trying to post my results in a data table. for example with a range of one cost on the row of the data table and the range of another cost on the column of the data table. however, for some reason the data table will not return any difference in numbers.
thanks in advance for the help in both questions!
Furthermore, i am trying to post my results in a data table. for example with a range of one cost on the row of the data table and the range of another cost on the column of the data table. however, for some reason the data table will not return any difference in numbers.
thanks in advance for the help in both questions!