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 an...
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.