Invalid Name Error

[TomFool]

I am getting an invalid name error with the following formula: =IF('7DESGL'!AD2 > 89, EXCELLENT, IF(AND('7DESGL'!AD2 > 79,'7DESGL'!AD2<90), GOOD, IF(AND('7DESGL'!AD2>75,'7DESGL'!AD2<80), SATISFACTORY, IF(AND('7DESGL'!AD3>64,'7DESGL'!AD3<75), LESS THAN SATISFACTORY, IF('7DESGL'!AD2<65, MUST IMPROVE))))) I am trying to get a response based on the number that appears in cell AD2 of the worksheet 7DESGL that is in the same workbook. I have checked the name of the sheet to make sure it is correct and it is. What is wrong with the above formula? Thank you for your help.

 

[Andrew Poulsom]

You need to enclose your text in quotes:

=IF('7DESGL'!AD2 > 89, "EXCELLENT", IF(AND('7DESGL'!AD2 > 79,'7DESGL'!AD2<90), "GOOD", IF(AND('7DESGL'!AD2>75,'7DESGL'!AD2<80), "SATISFACTORY", IF(AND('7DESGL'!AD3>64,'7DESGL'!AD3<75), "LESS THAN SATISFACTORY", IF('7DESGL'!AD2<65, "MUST IMPROVE")))))

 

[TomFool]

Wow. I spent so much time trying to figure out what was wrong with the link to the other cell that I completely overlooked that. Thank you so much for your help.