Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Match text in a cell, return Correct or Incorrect

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    Newcastle, Australia
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I am trying to do a spreadsheet to help me learn anatomy. I have a picture in the middle of the spreadsheet and some arrows pointing to diffent parts of it. I would like to enter the name of the part next to the arrow that points to it and have the cell next to it tell me if it is "CORRECT" or "INCORRECT". I have been playing with the EXACT function but cannot make sense of it. Any help would be greatly appreciated!!

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    202
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    i think all you need is =IF(B1=A1,"Correct","Incorrect") in C1, where B1 is the cell you type your answer into and A1 is the start of a list of anatomical bits.
    does that help?

    [ This Message was edited by: anno on 2002-04-18 20:00 ]

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    202
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    =IF(B1=A1,"Correct","Incorrect")
    [ This Message was edited by: anno on 2002-04-18 20:00 ]
    this one's a bit neater if B1 is empty:
    =IF(ISBLANK(B1),"",IF(B1=A1,"Correct","Incorrect"))

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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