=IF(A1<61,"Pass",IF(A1<81,"Credit","Distinction"))

--
Gary's Student


"Karen" wrote:

I need a formaula to do the following. If the total in cell A1 is between
0-60 I want it to display the word Pass in cell B1. If the If the total in
cell A1 is between 61-80 I want it to display the word Credit in B1. If the
If the total in cell A1 is between 81-100 I want it to display the word
Distinction in B1. I am sure someone would know how to do this!!! Please
help. You will make my life so much easier!!!
Cheers
--
Karen