+ Reply to Thread
Results 1 to 3 of 3

Formula to work out automatically the grades from marks scored on a paper

  1. #1
    Registered User
    Join Date
    04-05-2015
    Location
    Leeds
    MS-Off Ver
    2013
    Posts
    91

    Formula to work out automatically the grades from marks scored on a paper

    Hello,

    I am marking my students grades Is they a formula that will automatically put the grade in if a criteria is met for example

    0-10 = U
    11-15 - G
    16 - 20 =F
    21-25 = E
    ......

    65+ = A*

    Thank you in advance

    Steve
    Last edited by slock92; 02-22-2017 at 01:38 PM. Reason: Solved

  2. #2
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,785

    Re: Formula to work out automatically the grades from marks scored on a paper

    Amusing the criteria is in A1 use this
    =IF(A1<=10,"U",IF(A1<=15,"G",IF(A1<=20,"F",IF(A1<=25,"E"))))
    Add other levels in the similar fashion.
    Teach me Excel VBA

  3. #3
    Registered User
    Join Date
    04-05-2015
    Location
    Leeds
    MS-Off Ver
    2013
    Posts
    91

    Re: Formula to work out automatically the grades from marks scored on a paper

    Quote Originally Posted by ImranBhatti View Post
    Amusing the criteria is in A1 use this


    Add other levels in the similar fashion.
    Done Cheers

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Prepare Grades from Marks
    By a1q1 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-20-2016, 01:27 AM
  2. Postal Paper Work
    By Randy Putman in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-08-2016, 04:44 PM
  3. [SOLVED] formula to find name of person who scored highest score
    By rohit43 in forum Excel General
    Replies: 8
    Last Post: 11-21-2012, 11:58 AM
  4. Replies: 1
    Last Post: 11-19-2012, 03:58 PM
  5. [SOLVED] formula for comparing predicted grades vs actual grades
    By maths in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 10-25-2012, 11:23 AM
  6. Replies: 2
    Last Post: 10-10-2012, 05:03 PM
  7. I really want a way to find students grades based on their marks
    By master.osgood in forum Access Programming / VBA / Macros
    Replies: 1
    Last Post: 07-23-2010, 07:30 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1