Match text in a cell, return Correct or Incorrect

Gary Denham · Apr 18th, 2002, 08:34 PM

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!!

anno · Apr 18th, 2002, 09:00 PM

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 ]

anno · Apr 18th, 2002, 09:07 PM

Quote:

=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"))

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 18th, 2002, 08:34 PM	#1
Gary Denham New Member Join Date: Apr 2002 Location: Newcastle, Australia Posts: 4	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!!

Apr 18th, 2002, 09:00 PM	#2
anno Board Regular Join Date: Feb 2002 Posts: 202	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 ]