Results 1 to 8 of 8
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    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

    Braddy
    If you are a fool at forty, you will always be a fool

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: ISERROR Problem (Excel 2002)

    Why do you need an ISERROR here?

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    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. #4
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    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

    Braddy
    If you are a fool at forty, you will always be a fool

  5. #5
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: ISERROR Problem (Excel 2002)

    Hi Steve

    Can I refer you to my explanation to Hans.

    Thanks

    Braddy
    If you are a fool at forty, you will always be a fool

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: ISERROR Problem (Excel 2002)

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

  7. #7
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    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. #8
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    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
    Braddy
    If you are a fool at forty, you will always be a fool

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •