View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jonathan
 
Posts: n/a
Default NVL type function

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(OFFSET(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