Hi,
I am using the application.irr function in VBA code, and in some cases the array values produce an error. I believe this is if the IRR returns "#NUM!".
So I want to to return "0" if this is the case
x = Application.IRR(RAtTT)
I am using the application.irr function in VBA code, and in some cases the array values produce an error. I believe this is if the IRR returns "#NUM!".
So I want to to return "0" if this is the case
x = Application.IRR(RAtTT)
Last edited: