=if(B28<60,"F",if(B28<70,"D",if(B28<85,"C",If(B28< 93,"B","A"))))

< 60 F
60 - <70 D
70 - <85 C
85 < 93 B
else A

adjust to fit your actual criteria.

--
Regards,
Tom Ogilvy



"dave" wrote in message
...
i'm trying to put a value of a number to print out a letter such as 93 to
100=A, and so on here is what I

have,=IF(B28=93,"a","B"),if(then(B28<=85,"c"),if( then(b28<=70,"D"),if(then(
b28=69,"f"))), what do i have wrong.