Will this do?

First, define the following...

Insert Name Define

Name: BigNum

Refers to:

=9.99999999999999E+307

Click Ok

Secondly, custom format the cell as follows...

Format Cells Number Custom Type:

[=0]"N/A"

Then, try the following formula...

=LOOKUP(BigNum,CHOOSE({1,2},0,IRR(OFFSET(G10,0,Beg inOffset,1,NumOfPeriods
),0.01)*12))

Hope this helps!

In article .com,
"Jonathan" wrote:

Is there a NVL type function for excel?

What I am trying to accomplish is a fomula that will give an IRR value
if exists, but if IRR produces an #DIV/0!, return "N/A".

Right now I have the formula ...

=IF(ISERR(IRR(OFFSET(G10,0,BeginOffset,1,NumOfPeri ods),0.01)*12),"N/A",IRR(OFF
SET(G10,0,BeginOffset,1,NumOfPeriods),0.01)*12)

Which works fine, but it would be nice if I did not have to copy the
IRR part of the equation twice.

Thanks,

Jonathan