.9 = A ..8 to .89 = B ..7 to .79 = C ..6 to .69 = D <.6 = F
J John Oct 27, 2005 #2 =IF(A1>0.6,(IF(A1>0.69,(IF(A1>0.79,(IF(A1>0.89,(IF(A1>0.9,"A","B")),"B")),"C")),"D")),"F") Best regards John
=IF(A1>0.6,(IF(A1>0.69,(IF(A1>0.79,(IF(A1>0.89,(IF(A1>0.9,"A","B")),"B")),"C")),"D")),"F") Best regards John
B Bob Phillips Oct 27, 2005 #3 =LOOKUP(A1,{0,"F";0.6,"D";0.7,"C";0.8,"B";0.9,"A"}) -- HTH RP (remove nothere from the email address if mailing direct)
=LOOKUP(A1,{0,"F";0.6,"D";0.7,"C";0.8,"B";0.9,"A"}) -- HTH RP (remove nothere from the email address if mailing direct)
G Guest Oct 27, 2005 #4 Curt: Just to add another suggestion. The following will also work and it also handles the .9 and .6 as does Bob Phillips's =IF(A1>=0.9,"A",(IF(A1>=0.8,"B",(IF(A1>=0.7,"C",(IF(A1>=0.6,"D","F"))))))) Good luct TK
Curt: Just to add another suggestion. The following will also work and it also handles the .9 and .6 as does Bob Phillips's =IF(A1>=0.9,"A",(IF(A1>=0.8,"B",(IF(A1>=0.7,"C",(IF(A1>=0.6,"D","F"))))))) Good luct TK