GPA Calculation
Grade Point Average
GPA stands for Grade Point Average, this is a number that shows how well or how high you scored in your examination courses on average. GPA (grade point average) can be a widely used measure of a person's performance in school.
How to Calculate GPA
In this free GPA tutorial I will show you how to calculate GPA using Excel VBA Procedure.
We are going to Calculate GPA (grade point average) the usage of VBA Procedure in excel 2007-2016
calculate GPA using VBA in excel
To calculate GPA using vba in excel We need to calculate GPA (grade point average) with college students examination numbers list and We have an excel sheet with students courses scores.
By starting the Microsoft Excell VisualBasic (VBA) Applications window you could get right of entry to the VisualBasic (VBA) surroundings in Excel 2007-2016
To begin with, ensure that the DEVELOPER tab is seen withinside the toolbar in Excel 2007.
The Excel 2007 DEVELOPER tab is the tool that has the buttons on toolbar to open the MS excel VisualBasic (VBA) editor.
To display the Developer tab, click on the FILE menu and then choose the button Options beginning from the drop menu.
At the factor while the Excel Options dialogue window suggests up, click on, after that click on at the Customize Ribbon at the left side.
Click from the dialogue window Excel Options at the VBA Developer checkbox below the listing of MainTabs at the right. Then click on at the OK button.
From the toolbar at the top of the screen Select the VBA DEVELOPER tab. Then click on the Visual Basic option withinside the Code group.
Presently the Microsoft Excel VisualBasic VBA for Applications editor have to seem and also you type your VisualBasic VBA code.
From menu pick out insert command then click on Module.
The Microsoft Excel Visual Basic for Applications editor ought to to expose up then type feature (function) GPA (Function name is GPA) it is optional you can right other function name.
Function gpa(res As Double) If res <= 100 And res > 84 Then gpa = 4 ElseIf res <= 84 And res > 83 Then gpa = 3.9 ElseIf res <= 83 And res > 82 Then gpa = 3.75 ElseIf res <= 82 And res > 81 Then gpa = 3.6 ElseIf res <= 81 And res > 80 Then gpa = 3.5 ElseIf res <= 80 And res > 79 Then gpa = 3.4 ElseIf res <= 79 And res > 78 Then gpa = 3.3 ElseIf res <= 78 And res > 76 Then gpa = 3.2 ElseIf res <= 76 And res > 74 Then gpa = 3.1 ElseIf res <= 74 And res > 73 Then gpa = 3 ElseIf res <= 73 And res > 71 Then gpa = 2.9 ElseIf res <= 71 And res > 69 Then gpa = 2.8 ElseIf res <= 69 And res > 68 Then gpa = 2.7 ElseIf res <= 68 And res > 67 Then gpa = 2.6 ElseIf res <= 67 And res > 65 Then gpa = 2.5 ElseIf res <= 65 And res > 64 Then gpa = 2.4 ElseIf res <= 64 And res > 63 Then gpa = 2.3 ElseIf res <= 63 And res > 61 Then gpa = 2.2 ElseIf res <= 61 And res > 60 Then gpa = 2.1 ElseIf res <= 60 And res > 59 Then gpa = 2 ElseIf res <= 59 And res > 58 Then gpa = 1.9 ElseIf res <= 58 And res > 57 Then gpa = 1.8 ElseIf res <= 57 And res > 56 Then gpa = 1.7 ElseIf res <= 56 And res > 55 Then gpa = 1.6 ElseIf res <= 55 And res > 54 Then gpa = 1.5 ElseIf res <= 54 And res > 53 Then gpa = 1.4 ElseIf res <= 53 And res > 52 Then gpa = 1.3 ElseIf res <= 52 And res > 51 Then gpa = 1.2 ElseIf res <= 51 And res > 50 Then gpa = 1.1 ElseIf res <= 50 And res > 49 Then gpa = 1 Else gpa = 0 End If End Function
After that write method call known as gpa then click on button Save after which close visual basic editor.
Now write formula for N5 cell to calculate GPA in student excel sheet( = gpa(N5)).
The gpa automaticaly calculates by Excel for given college student marks.
copy this formula (N5 Cell) for other student marks and paste it in Cell N6 to N11.
Its all.
How to insert dash instead of GPA 0(zero)?
ReplyDeleteTry this code place of Zero
DeleteElse
gpa = "-"
End If
End Function