Formula Help

[lecxez]

I am trying to insert the "IFERROR" into the following formula ( =C4*(1+C5/C6)^(C6*C7 ) to correct a #DIV/0! error, but try as I might am unable to do so. Can anyone help me? I am using Excel 2007.

Robert

 

[Domenic]

Try...

=IFERROR(C4*(1+C5/C6)^(C6*C7 ),"")

Alternatively, you can use the following formula instead...

=IF(N(C6),C4*(1+C5/C6)^(C6*C7 ),"")

In the first formula, the full calculation is always carried out before determining whether there's an error. Whereas, in the second formula, the calculation only takes place when C6 doesn't equal 0. So, technically, the second formula is more efficient.

Hope this helps!

 

[Ragnar1211]

you have not explained what you want to evaluate as an error, and what your result should be if it is not. But here is a guess:

=C4*(1+iferror(C5/C6,0))^(C6*C7 )

 

[lecxez]

Domenic and Jerry; Thank you both for the answers to my formula problem, all examples worked. Domenic your explanation of your example was also very helpful in helping me to understand the logic required. Thanks again

Robert