Results 1 to 5 of 5
  1. #1
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts

    If contains (2002)

    =IF(C15=C16,"CORRECT","WRONG")

    I am looking to add =IF(C15 contains C17,"CLOSE" - The cells are formatted as text. Is this possible?

  2. #2
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: If contains (2002)

    Something like this?

    =IF(C15=C17,"CLOSE",IF(C15=C16,"CORRECT","WRONG"))
    Regards,
    Rudi

  3. #3
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: If contains (2002)

    Thanks Rudi, but I need contains, not =. I'm not sure if that's possible?

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

    Re: If contains (2002)

    Try

    =IF(C15=C16,"CORRECT",IF(ISERROR(SEARCH(C17,C15)), "WRONG","CLOSE"))

  5. #5

Posting Permissions

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