+ Reply to Thread
Results 1 to 2 of 2

problem with grading of my result

  1. #1
    Registered User
    Join Date
    05-04-2017
    Location
    NIGERIA
    MS-Off Ver
    2007
    Posts
    2

    problem with grading of my result

    pls house my report sheet in the grade column grades for cells where subjects are not offered it grades F9 when i use this formular =IF(G6>=75,"A1",IF(G6>=70,"B2",IF(G6>=65,"B3",IF(G6>=60,"C4",IF(G6>=55,"C5",IF(G6>=50,"C6",IF(G6>=45,"D7",IF(G6>=40,"E8","F9")))))))) pls help out

  2. #2
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,212

    Re: problem with grading of my result

    =if(g6="","",vlookup(g6,{0,"f9";40,"e8";45,"d7";50,"c6";55,"c5";60,"c4";65,"b3";70,"b2";75,"a1"},2,true))

+ 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. Sales grading
    By makinmomb in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-07-2015, 07:44 AM
  2. Help on creating report grading calculation method
    By jimbosi in forum Excel General
    Replies: 1
    Last Post: 11-19-2014, 09:02 PM
  3. input box problem, cell filtering problem, result display while locking sheet
    By croozin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-01-2013, 08:52 AM
  4. [SOLVED] Grading problem
    By kipronopaul in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-05-2012, 02:13 AM
  5. Grading columns
    By travisdh in forum Excel General
    Replies: 3
    Last Post: 10-02-2011, 06:29 PM
  6. grading
    By senduk73 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-07-2009, 03:40 PM
  7. Grading formula
    By dennisc in forum Excel - New Users/Basics
    Replies: 9
    Last Post: 10-24-2007, 11:18 PM

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