Invalid procedure call or argument - overflow?

[sonic8]

@sonic8 took a different approach and loaded the values to variables. But in so doing, he applied the unary negation to the variable BEFORE the exponentiation could occur, and so exhibited the same problem.

I just tried to translate the OP's problem description into VBA code as simple and accurate as possible to create a runable reproduction scenario for the error message. - I don't have any clue about XIRR and its prerequisites.

 

[The_Doc_Man]

I just tried to translate the OP's problem description into VBA code as simple and accurate as possible to create a runable reproduction scenario for the error message. - I don't have any clue about XIRR and its prerequisites.

Nor did it matter that you knew what XIRR meant. (For that matter, neither did I.) Your experiment demonstrated my applied-math point perfectly. All I wanted to do was to give a definitive answer of WHY the problem occurs.

 

[arnelgp]

All I wanted to do was to give a definitive answer of WHY the problem occurs.

XIRR vba function, is not a simple straightforward exponentiation of two variables.
it is repeated over and over (for 1000 times or another variable is less than 0.00001 value).

 

[The_Doc_Man]

XIRR vba function, is not a simple straightforward exponentiation of two variables.
it is repeated over and over (for 1000 times or another variable is less than 0.00001 value).

I didn't care so much about XIRR. I appreciate that there is some considerable structure and delicacy to it. I was answering the narrow technical question of why the error occurred and that all I was trying to do. It should not be construed as attacking anyone's suggested solution.