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

    ISERROR ?? (Excel 2002)

    Hi

    I am struggling with this formula any ideas please, if I enter it in the cell it appears to be text and not a formula sgptotal and sgpcheck are Named ranges

    =IF(ISERROR(sgptotal<sgpcheck,"Below Target","On Target"),"",sgptotal<sgpcheck,"Below Target","On Target")

    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 ?? (Excel 2002)

    The formula doesn't make sense: ISERROR has only one argument, not three, and IF has three arguments, not five. I'm not sure what exactly you are trying to accomplish, perhaps the following will do what you want:
    <code>
    =IF(ISERROR(sgptotal<sgpcheck),"",IF(sgptotal<sgpc heck,"Below Target","On Target"))
    </code>
    If it is still displayed as text, make sure that the cell containing the formula is not formatted as Text in the Number tab of Format | Cells...

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

    Re: ISERROR ?? (Excel 2002)

    Hi Hans

    What I was trying to achieve was to remove #DIV/0 as these cells are reliant on other data entered elswhere.

    Your formula works perfectly, thanks very much I take note that ISERROR only has one argument.

    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
  •