=IF(C2=36,"Passing",IF(C2<=36,"Unsatisfactory"))

Try this one, you needed to add another IF and if you want text you need to
put quotes around the word.

"Creolekitten via OfficeKB.com" wrote:

I'm having a problem with my formula to get Excel to print text as a result.
The formula that I am using is:
=IF(C2=36,Passing,(C2<=36,Unsatisfactory))
Can someone please tell me what I am missing? I am a #NAME? message.
Thank you,
Bernie

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200607/1