Need formula to populate text in anoher cell

maybe
=LOOKUP(X9,{0,1,61,71,81,91},{"Incomplete","F","D","C","B","A"})

Unfortunately that formula is not working. If you add 3 columns and you want the last column to give a text grade from percentage numbers added together, is there another way?

Originally Posted by mcbrownhouse

Trying to create a formula that will give a text grade. example
=SUM(30*a2)+(20*b2)+(20*c2)+(25*d2)+(5*e2)+5*f2)) this formula should give a total of grade precentages.

=IF(X9>90%, “A”, IF (X9>80%, “B”, IF(X9>70%, “C”,IF(X9>60,”D”,IF(X9>0%, “F”, Incomplete))))) This formula should poplulate last colmun to a letter grade. Any help would be greatly appreciated.

Prior to your example X9 is the percentage say X9 is =84%
the formula i gave will give you The letter B because its greater than 80%

put it in another column.

if you have a sample workbook maybe we can look at it better and what is the exact table of grades for that
lookup.xls

Hopefully you have worksheet 2, allhghlighted areas are supposed tobe percentages, thank you in advance for your help

Originally Posted by vlady

Prior to your example X9 is the percentage say X9 is =84%
the formula i gave will give you The letter B because its greater than 80%

put it in another column.

if you have a sample workbook maybe we can look at it better and what is the exact table of grades for that
Attachment 179426

you can upload a file here.
click edit button below your post ->go advanced->manage attachment

excel exercise(1).xlsx

look at the other computation if you can adopt it. thanks.