Home

FORMULA ASSISTANCE

%3CLINGO-SUB%20id%3D%22lingo-sub-1262369%22%20slang%3D%22en-US%22%3EFORMULA%20ASSISTANCE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1262369%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Everyone%3C%2FP%3E%3CP%3EI%20was%20wondering%20if%20I%20can%20get%20support%20in%20creating%20a%20formula%20for%20the%20following%3A%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20How%20do%20I%20add%20up%20letters%20(%20P%2C%20M%2C%20D)%20or%20text%20(Pass%2C%20Merit%20%2CDistinction)%20in%20a%20row%20and%20get%20an%20overall%20grade%20as%20a%20letter%20or%20text%20in%20Excel%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%3A%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20GRADES%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BOVERALL%20GRADE%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20P%26nbsp%3B%20%26nbsp%3BM%26nbsp%3B%20%26nbsp%3BP%26nbsp%3B%20%26nbsp%3B%20M%26nbsp%3B%20%26nbsp%3BD%26nbsp%3B%20P%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1262369%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1262393%22%20slang%3D%22en-US%22%3ERe%3A%20FORMULA%20ASSISTANCE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1262393%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F599734%22%20target%3D%22_blank%22%3E%40Bran20%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20I%20remember%20Overall%20Grade%20is%20the%20weighted%20average%20grade.%20If%20so%2C%201)%20weights%20are%20to%20be%20defined%3B%202)%20credits%20for%20each%20grade%20to%20calculate%20average%2C%20e.g.%20P%3D3%2C%20M%3D2%2C%20D%3D1%20(or%20P%3D15%2C%20M%3D10%2C%20D%3D1)%20and%3B%203)%20define%20the%20logic%20based%20on%20which%20return%20the%20text%20for%20overall%20grade%20after%20average%20is%20found%2C%20e.g.%20closest%20to%20average%2C%20or%20smallest%20and%20not%20less%2C%20or%20largest%20and%20not%20more%3B%20etc.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1262410%22%20slang%3D%22en-US%22%3ERe%3A%20FORMULA%20ASSISTANCE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1262410%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BThanks%20for%20your%20help.%20Will%20have%20ago%20and%20let%20you%20know%20how%20it%20went.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi Everyone

I was wondering if I can get support in creating a formula for the following:                                            How do I add up letters ( P, M, D) or text (Pass, Merit ,Distinction) in a row and get an overall grade as a letter or text in Excel?

 

Example:        GRADES                           OVERALL GRADE                                                                                                      P   M   P    M   D  P  

2 Replies
Highlighted

@Bran20 

As I remember Overall Grade is the weighted average grade. If so, 1) weights are to be defined; 2) credits for each grade to calculate average, e.g. P=3, M=2, D=1 (or P=15, M=10, D=1) and; 3) define the logic based on which return the text for overall grade after average is found, e.g. closest to average, or smallest and not less, or largest and not more; etc.

Highlighted

@Sergei Baklan Thanks for your help. Will have ago and let you know how it went.