Need Help Creating a Letter Grade excel formula to be used in SharePoint.

Hey everyone! Thank you so much in advance for your help!

Okay now the issue, I have read many different posts on the site that explain how to take Letter Grades Lets say for example A, B, C, D and F and add a numeric value to them and then average it and convert it back to a Letter grade which shows the average using another table to look it up - my issue is I'm using this formula for a SharePoint Survey and there is no way of looking up from another table to my knowledge

So my question remains - How do I Average out letter Grades and make the result a letter grade without having to add a separate table? Thanks!!

With grades in A1:A10,

=MID("FDCBA", ROUND(AVERAGE(SEARCH(A1:A10, "FDCBA")), 0), 1)

The function MUST be confirmed with Ctrl+Shift+Enter instead of just Enter.

Row\Col	A	B	C
1	A	B	B1: {=MID("FDCBA", ROUND(AVERAGE(SEARCH(A1:A10, "FDCBA")), 0), 1)}
2	B
3	C
4	C
5	A
6	A
7	B
8	A
9	A
10	A

With A2:A7 contains A,B,C,D,F,...

This will gives average of code values, then converts back number

=CHAR(ROUND(AVERAGE(INDEX(CODE($A$2:$A$7),)),0))

also maybe to suppress space
array entered

Formula:

Please Login or Register  to view this content.

Originally Posted by bebo021999

With A2:A7 contains A,B,C,D,F,...

This will gives average of code values, then converts back number

=CHAR(ROUND(AVERAGE(INDEX(CODE($A$2:$A$7),)),0))

That would, in some circumstances, return an "E", no?

Originally Posted by shg

That would, in some circumstances, return an "E", no?

Yes, I mean it will returns letter

But there is no grade "E"

Did you read post #6?

The formula MUST be confirmed with Ctrl+Shift+Enter instead of just Enter.

You're welcome.