IF Statement with nested ISERROR help needed

[dgmcdo]

I inherited a spreadsheet template we use from a colleague recently that looks at large amounts of client information to determine correct billings. I just recently noticed this error.

+IF(ISERROR(CM15+CR15+CW15+<b>DB15</b>),0,CM15+CR15+CW15+DB15)+<b>CC15</b>

The problem is that if the formula column DB15 returns an #N/A value it returns the value from column CC15 even if there are values in columns CM, CR and CW. The intent of the formula is to return the sum of columns CM, CR, CW and CC; the columns with values.

Is there a simple way to rewrite this so that it will only return a 0 for the error field and sum the rest or will I have to write an IF with a nested ISError for each column (CM, CR, CW and DB).

Thanks

 

[MrKowz]

Ideally, correct the error at the source with an IF(ISERROR( statement, instead of further down the line. This will eliminate potential issues in future calculations, as well as eliminate the need for complicated formulas (such as this).