Nesting Iferror and or formulas

[Deuce Bucksman]

Hello, gurus.

Is there anyone who can tell me what I'm doing wrong? I'm trying to make it so if there is an error, or there is an IRR larger than 1,000 then the calculation will reflect NA. Any guidance would be much appreciated. Thanks!

=IFERROR((1+IRR(F68:CG68,0.01))^4-1,"NA"),or(if((1+IRR(F68:CG68,0.01))^4-1>1000,"NA"))

 

[T. Valko]

Hello, gurus.

Is there anyone who can tell me what I'm doing wrong? I'm trying to make it so if there is an error, or there is an IRR larger than 1,000 then the calculation will reflect NA. Any guidance would be much appreciated. Thanks!

=IFERROR((1+IRR(F68:CG68,0.01))^4-1,"NA"),or(if((1+IRR(F68:CG68,0.01))^4-1>1000,"NA"))

I don't know anything about financial functions but here's how to construct the formula to do what you want.

=IF(ISERROR((1+IRR(F68:CG68,0.01))^4-1),"NA",IF((1+IRR(F68:CG68,0.01))^4-1>1000,"NA",(1+IRR(F68:CG68,0.01))^4-1))

 

[Deuce Bucksman]

Thanks, Biff. You could've fooled me, this works perfectly. Thanks so much for your help. I was wracking my brain on this for almost a half an hour yesterday. I owe you!

 

[T. Valko]

Thanks, Biff. You could've fooled me, this works perfectly. Thanks so much for your help. I was wracking my brain on this for almost a half an hour yesterday. I owe you!

You're welcome. Thanks for the feedback!