=IF(A1="","N/A",IF(A1<0.2,"E",IF(A1<0.4,"D",IF(A1<0.6,"C",IF(A1 <0.8,"B",IF(A1<1,"A","ERROR"))))))
You can change the percentages, the letters or nest up to 2 more IF
formulas.
Saludos
NlCO
--
NlCO
------------------------------------------------------------------------
NlCO's Profile:
http://www.excelforum.com/member.php...o&userid=26123
View this thread:
http://www.excelforum.com/showthread...hreadid=401868