I am calculating IRR's within a loop with the code below. If an error occurs when calculating the IRR, I need to assign a value of 0 to the variable and continue on to the next loop. Can anyone suggest a way to do this? Iserror doesn't work, so I need error handling instead.
for ctr = 1 to 100
If iserror(irr(varray(), -.09) then
final = 0
final = irr(varray(), -.09)