Forum Discussion
FORMULA ASSISTANCE
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 ,Distinct...
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.
SergeiBaklan Thanks for your help. Will have ago and let you know how it went.