+ Reply to Thread
Results 1 to 3 of 3

Grade forumula

  1. #1
    Registered User
    Join Date
    06-25-2015
    Location
    HYDERABAD
    MS-Off Ver
    2013
    Posts
    46

    Grade forumula

    Dear All,

    Please help me in formula for the grade please find the attached file.

    1. Under Summary Table for Exercise Grade should come according to the criteria given in criteria table. (e.g if Score is less than 3 then grade should be light, if Score is less between 3 to 6 then grade should be moderate, if Score is less than 6 then grade should be Vigerous)

    2. require the same above conditions for all the activities mentioned in column Activity in Summary Table (Exercise, House hold, Sports, Recreation, 1 Met)
    Screenshot (36).png

    Regards
    Rush
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: Grade forumula

    in E4
    =LOOKUP(D4,{0,3,6},{"Light","Moderate","Vigorous"})
    copy down to E7

    in E8
    =VLOOKUP(D8,E26:F28,2,1)
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: Grade forumula

    There's an error in your data.

    Criteria Table
    Sports Category Doing Aerobics has a score of 3 to 6
    Yet the Summary score for this is 6.83 which is not "from 3 to 6"

    Or is this Criteria Table a "one to many" for each category and youve only list the scores once?
    It's not clear.

+ 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. Conditional formatting target grade against actual grade
    By skardi in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-10-2015, 01:58 PM
  2. Replies: 6
    Last Post: 03-12-2014, 12:16 PM
  3. Replies: 5
    Last Post: 11-30-2013, 01:28 PM
  4. Replies: 5
    Last Post: 02-17-2013, 03:29 PM
  5. Conditional formatting to reflect exam grade compared to predicted grade
    By strangecharm in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-20-2012, 09:33 AM
  6. Student grade inputting and grade percentage calculations
    By confusedteacher in forum Excel General
    Replies: 2
    Last Post: 10-23-2011, 07:50 PM
  7. Creating a grade book (forumula issue)
    By phathead in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-10-2007, 11:03 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