View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default Why doesn't excel 2003 accept this "IF" grade formula?? Please HE

=LOOKUP(B3,{0,59,63,69,72,75,79,82,85,89,92},{"F", "D","D+","C-","C","C+","B-","B","B+","A-","A"})

"VD" wrote:

=IF(B392,"A",IF(B389,"A-",IF(B385,"B+",IF(B382,"B",IF(B379,"B-",IF(B375,"C+",IF(B372,"C",IF(B369,"C-",IF(B363,"D+",IF(B359,"D","F"))))))))))

If i take out the B363 & the B359 argument it works.
--
VD, mistress in progress