Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Logical Functions

 

=IF(A289,A,IF(A279,B, IF(A269,C,IF(A259,D,F))))

Input the formula: =IF(A2>89,"A",IF(A2>79,"B", IF(A2>69,"C",IF(A2>59,"D","F"))))