Try,

=if(score85,"pass Good",if(score=70,"pass","fail"))

should serve your purpose.

--


library Wrote:
hi,
I'm asked to mark "fail" if there is a score under 70, or mark "pass".
I
have to use function OR.

and I'm also asked to mark "good" if the total score is over 85. I have
to
use function AND.

I was wondering how it is possible, because in those functions there is
no
your own named value if the value is true or false. All it displays in
those
cases is "true" or "false".
Is my instructor wrong when asking these questions?
please help , thanks


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=535210