# Formula Help

#### lecxez

##### New Member
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

### 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
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
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
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

Replies
3
Views
42
Replies
3
Views
28
Replies
5
Views
35
Replies
13
Views
86
Replies
6
Views
54