Why does my formula display "RUE" rather than a numerical value?

[rmbmst1972]

Dear Sir or Madam:

My name is Robert, and I am very proud of myself as I am gaining more knowledge about creating complex Excel formulas to help me become a better middle school teacher. I am extremely close to creating a formula that will return a "2" provided a student's answer consists of more than just the word "Sara". If a student's answer only consists of the word "Sara", then I want to give partial credit for at least having "Sara". The partial credit value assigned is "1". I created the following formula, but it seems to only perform 50% of my task. Excel returns a "1" when I simply enter "Sara" which is the good news. The bad news is Excel returns "TRUE" instead of a "2" when "Sara" and other words are entered into the same cell. Any assistance you can provide will be greatly appreciated:

=IF(E3="","",IF(AND(ISNUMBER(SEARCH("sara",E3)),IF(E3<>"sara",2,0)),ISNUMBER(SEARCH("sara",E3)),IF(E3="sara",1,0)))

Sincerely,
Robert

 

[shg]

=IF(E3="sara", 1, IF(ISNUMBER(SEARCH("sara", E3)), 2, ""))

 

[rmbmst1972]

Re: Why does my formula display "TRUE" rather than a numerical value?

=IF(E3="sara", 1, IF(ISNUMBER(SEARCH("sara", E3)), 2, ""))

Thank You Very MUCH!!!...I truly don't know what I would do without Mr. Excel.

Robert

 

[shg]

You're welcome.