We’ve run into a case where XIRR returns significantly different values from Excel and it effecting our ability to search for a target result using a goal seek like algorithm.
When Excel returns a very large (> 1000000 …...#2 @kmonson By using sample files and code for testing, we can...value will cause the later comparisons to always pass because of...