skip if error application.irr

[MetLife]

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)

 

[Domenic]

Try...

    Dim x As Variant

    x = Application.IRR(RAtTT)


    If IsError(x) Then
        x = 0
    End If

Hope this helps!