Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Edison, New Jersey, USA
    Posts
    215
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Simplified Formula (EXCEL 2003)

    For the attached spreadsheet, is there a way to simplify the formula in C2:C5?
    i.e. remove the ISNUMBER function.
    Attached Files Attached Files

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

    Re: Simplified Formula (EXCEL 2003)

    You could use
    <code>
    =IF(COUNTIF($A$2:$A$10,B2),"True","Error")
    </code>
    or even
    <code>
    =COUNTIF($A$2:$A$10,B2)
    </code>
    In the latter case, format the cells with the custom format
    <code>
    "True";;"Error"</code>

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Simplified Formula (EXCEL 2003)

    Not shorter than Hans' but without the isnumber

    =IF(ISNA((VLOOKUP(B2,$A$2:$A$8,1,FALSE))), "Error","True")
    Jerry

  4. #4
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Edison, New Jersey, USA
    Posts
    215
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Re: Simplified Formula (EXCEL 2003)

    Thank You!

Posting Permissions

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