gpa

  1. M

    Ignoring Empty Cells in Multiple Formulae

    All Each month I get a report of majors studying in my department. As we have two "concentrations" (and old and new designations for each concentration) the report is a bit complex. Further, newly admitted students who have declared their majors are shown, even though they have not yet earned...
  2. R

    Targeting top result for each entry

    Hi, I have a workbook that lists all terms attended for each student as well as their GPA for that term in descending order. What I am trying to achieve is target the top entry for each student, which will give me the last term attended as well as their last known GPA. Please see a short example...
  3. R

    About VLOOKUP in Excel (Find all grades and calculate the GPA)

    Hi, everyone. I found a problem in Excel. Can any better method be used to calculating two GPA (E2 and E7 in the following)? Example: Table A: Table B: Now, I am using following formulas in Table A...
  4. A

    calculate trend as a value?

    Hello everyone, I'm trying to calculate the "trend" in student GPAs as a value of some sort, indicating if the overall trend is negative, positive, or flat. I've done some digging but can seem to figure out what this value would even be called. Possibly r-squared when you add a trendline to a...
  5. J

    Countifs(Range,Criteria,AND(OR(range2,criteria2,range3,criteria3))

    I am trying to insert an and/or argument into countifs but can't get it to work. I tried SUMPRODUCT(ISNUMBER(MATCH,RANGE,CRITERIA,0))*ISNUMBER(ETC)) Can't figure out how to do it. For example <tbody> Student A GPA SAT ACT Student B 3.0 900 21 Student C 3.4 1200 Student D 3.0 1080 25...
  6. N

    gpa calculator

    hi, i was wondering if someone could help me with calculating my gpa for 5 subjects. I am searching for a online gpa calculator and also a gpa to percentage converter. Please help me with the steps to use the calculator, if any.
  7. M

    Weighted Average

    Sorry if this post has been answered elsewhere, I searched but did not find the answer I need. Trying to average weighted scores. We have x1 number of students with a y1 GPA, plus x2 number of students with a y2 GPA. How do I manage to get the "total" (blended) average across the two groups...
  8. W

    Excel Formula to calculate GPA

    This is what my row looks like I want to add a column at the end that calculate GPA (Letter Value/Number of classes).. Could someone please help me?? I try the "IF" formula but is not working :confused: <style>table { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px...
  9. B

    GPA Calculator Help

    The first part of this problem required me to make a userform to ask about a class year, course info, and the grade a student received in the class. I have done that. The second part that I'm having trouble with is the gpa calculation based off the user input pulled from the userform. I need to...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top