=IF(C18=1,"A",LOOKUP(C18,{2,80,90},{"D","C","B"}))

HTH
Jason
Atlanta, GA

-----Original Message-----
I'd like to enter a formula where if c1 is greater than 1
then c18 equals A
if c1 is
between 90-100 then
c18 equals B
if c1 is
between 80-89 then
c18 equals C
if c1 is
less than 80 then
c18 equals D

Thanks for any help.

.