# Thread: ISERROR Problem (Excel 2002)

1. ## ISERROR Problem (Excel 2002)

Hi
I am trying ot get an ISERROR into this formula with no success, can anyone oblige please

=SUM((((CDEC37+CDEE37)*P107)+(CDEG37*P108)+(CDEI37 *P109))*CDEG39)*G74*CDEC41

Many Thanks

2. ## Re: ISERROR Problem (Excel 2002)

Why do you need an ISERROR here?

3. ## Re: ISERROR Problem (Excel 2002)

Like Hans, I wonder about the need, but you could do something like this:
=IF(ISERROR(((((CDEC37+CDEE37)*P107)+(CDEG37*P108) +(CDEI37*P109))*CDEG39)*G74*CDEC41),"Error",((((CD EC37+CDEE37)*P107)+(CDEG37*P108)+(CDEI37*P109))*CD EG39)*G74*CDEC41)

Note: The SUM is redundant. You never state what you want to display if you get an error, so I just display the text "Error".

Steve

4. ## Re: ISERROR Problem (Excel 2002)

Hi Hans

Sorry to take so long to get back to you, but my insisted I paint the garden fence.

Explanation if CDEG39 Is empty I get a value error in H78 and G78 relies on H78 at least containing a zero.

Many Thanks

5. ## Re: ISERROR Problem (Excel 2002)

Hi Steve

Can I refer you to my explanation to Hans.

Thanks

6. ## Re: ISERROR Problem (Excel 2002)

What do CDEG39 etc. refer to? Single cells, or ranges consisting of multiple cells?

7. ## Re: ISERROR Problem (Excel 2002)

I get it if the named cell, CDEG39, is empty it acts as a zero.

I don't how G78 and H78 work with your formula since they are not in it.

Steve

8. ## Re: ISERROR Problem (Excel 2002)

Hi Steve

The formula you supplied which works fine once I changed the Error Text to ,0, this formula is placed in H78 In one worksheet where I need the result,
whilst the named cells which are individual cells on another worksheed called Customer Data Entry hence the CDEG39 etc.

I hope this answers Hans's question aswell.

Thanks