The IRR function returns a missing value when payment values switch between positive and negative values multiple times


In a particular scenario, the IRR function returns a missing value and the following note in your SAS® log:

NOTE: Invalid argument to function IRR

This issue occurs after payment values switch between positive and negative values multiple times in the IRR function.

You receive the same note in the SAS log when you use the IRR argument with the FINANCE function. Again, the note appears along with a missing value as the result of the FINANCE function after you supply payment values that switch between positive and negative multiple times.