Forum Discussion
Formula to calculate CGPA
I needs formula for CGPA in Microsoft Excel?
If ;
A. The Cells content of G13 is first semester total unit and H13 is total Grade Point
B. The Cells contents of G23 is Second SEMESTER total unit and H23 is total Grade Point
and
CGPA = (G13+G23)/(H13+H23)
What will be the formula to calculate CGPA?
THANKS
If ;
A. The Cells content of G13 is first semester total unit and H13 is total Grade Point
B. The Cells contents of G23 is Second SEMESTER total unit and H23 is total Grade Point
and
CGPA = (G13+G23)/(H13+H23)
What will be the formula to calculate CGPA?
THANKS
2 Replies
You can calculate CGPA in Excel using the formula:
=(H13+H23)/(G13+G23)
Simply enter your semester's total units and grade points in the respective cells, and Excel will give you the CGPA automatically.If you ever need a quicker way without manual calculations, you can also try this https://cgpatopercentageonline.com/sgpa-to-cgpa-calculator/ for instant results.
- You have posted on the Microsoft Learn community board which is all about exams, certification and training.
You might get a better response on the Excel community board https://techcommunity.microsoft.com/t5/excel/bd-p/ExcelGeneral
