Formula Help

lecxez

New Member
Joined
Jan 3, 2005
Messages
44
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
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Domenic

MrExcel MVP
Joined
Mar 10, 2004
Messages
19,294
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

Well-known Member
Joined
Jul 10, 2008
Messages
571
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:

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

lecxez

New Member
Joined
Jan 3, 2005
Messages
44
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
 

Watch MrExcel Video

Forum statistics

Threads
1,108,502
Messages
5,523,295
Members
409,508
Latest member
Afc

This Week's Hot Topics

Top