Converting Percentage Grade to Letter Grade

[Rob0424]

I am trying to create a formula that converts a percentage grade to a letter grade but the letter grade cell does not seem to recognize the percentage formula and returns "F" no matter what. Here are the formulas I am using:

Percentage Grade:
=SUMPRODUCT((G5:T5 = "Yes") * G1:T1) / SUMIF(G5:T5, "<>N/A", G1:T1)

Letter Grade:
=IF(E5>=90,"A",IF(E5>=80,"B",IF(E5>=70,"C",IF(E5>=60,"D","F"))))

Could someone help me fix this? Thank you in advance

 

[duggie33]

You could try 0.9 rather than 90 and see if that works. The same would apply for the other values also.

Hope that helps,

Doug

 

[Rob0424]

That worked. Thank you

Also, anyone have any ideas on how I can adjust this formula to include a separate cell that includes a ranking 1-10 instead of Yes, No or N/A?

=SUMPRODUCT((G5:T5 = "Yes") * G1:T1) / SUMIF(G5:T5, "<>N/A", G1:T1)

For this formula and row, cell D5 has a ranking of 1-10 and somehow I want to include how good of a ranking that is given into the score. as well. FYI, G1:T1 provide weighted percentages to use when calculating the score based on Yes, No, N/A answers.

 

[duggie33]

Please provide some sample data and expected results.

MrExcel has a tool called “XL2BB” that lets you post samples of your data, allowing us to copy/paste it to our Excel spreadsheets to work with the same data you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that this board also has a "Test Here” forum. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

Thanks,

Doug