A Middle School Math Teacher Needs Help with a SEARCH Formula

[bmst23]

Hello...I am a middle school math teacher who is trying to create a SEARCH formula that will require more than a one-word answer, and I also need the formula to return a '2' for true and a '0' for false. For example, the answer to a particular word problem is 'Sara', and students have to justify why they believe the answer is 'Sara'. I am trying to create the following formula to not give any credit for only entering 'Sara' as an answer:


=IF(E2="","",IF(OR(ISNUMBER(SEARCH(<>"Sara",E2))),"2","0"))


I am not so much concerned with what else they enter beyond 'Sara' as I am about only entering 'Sara'. Any assistance you can provide will be greatly appreciated.


Robert

 

[AhoyNC]

Maybe something like this:

Excel Workbook
	E	F
1
2	Sara	0
3	Sara is the one	2
4	Is it Sara	2
Sheet

 

[steve the fish]

So you need a cell that contains sara but doesnt equal exactly sara?

=IF(E2="","",IF(ISNUMBER(SEARCH("sara",E2)),IF(E2<>"sara",2,0),0))

 

[Fluff]

How about
=AND(ISNUMBER(SEARCH("sara",E2)),E2<>"sara")*2

 

[rmbmst1972]

So you need a cell that contains sara but doesnt equal exactly sara?

=IF(E2="","",IF(ISNUMBER(SEARCH("sara",E2)),IF(E2<>"sara",2,0),0))

___________________________________________________________________________________________________

Hello.,..The above formula works perfectly. However, I recently discovered I need the formula modified. I am giving another version of the same assessment that contains the "Sara" problem from above. I need the formula to accept "minimum", "maximum" and "range" as answers, but doesn't exactly equal "minimum", "maximum" and "range". In other words, I want the same formula structure as the "Sara" problem above with three required answers rather than one. Your assistance is greatly appreciated!

Robert