+ Reply to Thread
Results 1 to 12 of 12

Formula for grades

  1. #1
    Registered User
    Join Date
    06-06-2013
    Location
    mumbai
    MS-Off Ver
    Excel 2007
    Posts
    40

    Question Formula for grades

    I HAVE MARKS ON SHEET
    Column A --- Column B -- --------Column C column D
    1 45 ----- 56 ---------- 30
    2 30------- 45 -------- 56
    3
    i want formula in '"column D" if column A or B or C if any column mark is below 35 than display fail or mark are above 35 than display pass
    pls help with the formula

  2. #2
    Registered User
    Join Date
    06-01-2013
    Location
    Columbus, ms
    MS-Off Ver
    Excel 2013
    Posts
    68

    Re: Formula for grades

    Try this one
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Does that accomplish what you are looking for?

  3. #3
    Valued Forum Contributor
    Join Date
    10-29-2012
    Location
    Mojokerto,Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    554

    Re: Formula for grades

    try this
    =INDEX({"Pass","Fail"},(SUMPRODUCT((A1:C1<35)*1))+1)

  4. #4
    Registered User
    Join Date
    06-06-2013
    Location
    mumbai
    MS-Off Ver
    Excel 2007
    Posts
    40

    Re: Formula for grades

    thanks very much it works

  5. #5
    Registered User
    Join Date
    06-06-2013
    Location
    mumbai
    MS-Off Ver
    Excel 2007
    Posts
    40

    Re: Formula for grades

    i have another problem
    if column A is 60 to 74 display fist class in column B , if column A is 75 to 89 display DISTINCTION in column B , if column A is 90 to 100 display merit in column B.
    can u help me with the formula pls

  6. #6
    Registered User
    Join Date
    06-01-2013
    Location
    Columbus, ms
    MS-Off Ver
    Excel 2013
    Posts
    68

    Re: Formula for grades

    try this one
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  7. #7
    Valued Forum Contributor
    Join Date
    10-29-2012
    Location
    Mojokerto,Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    554

    Re: Formula for grades

    =INDEX({"first class","Distinction","Merit"},MATCH(A1,{60,75,90}))

  8. #8
    Registered User
    Join Date
    06-06-2013
    Location
    mumbai
    MS-Off Ver
    Excel 2007
    Posts
    40

    Re: Formula for grades

    Its not working

  9. #9
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Formula for grades

    ...As i said don't spend our time posting duplicate threads.

    http://www.excelforum.com/excel-form...ple-valus.html
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  10. #10
    Registered User
    Join Date
    06-06-2013
    Location
    mumbai
    MS-Off Ver
    Excel 2007
    Posts
    40

    Re: Formula for grades

    BOTH FORMULA'S ARE NOT WORKING

  11. #11
    Registered User
    Join Date
    06-06-2013
    Location
    mumbai
    MS-Off Ver
    Excel 2007
    Posts
    40

    Re: Formula for grades

    Thanks it worked
    thanks very much

  12. #12
    Registered User
    Join Date
    06-01-2013
    Location
    Columbus, ms
    MS-Off Ver
    Excel 2013
    Posts
    68

    Re: Formula for grades

    Quote Originally Posted by Ghozi Alkatiri View Post
    =INDEX({"first class","Distinction","Merit"},MATCH(A1,{60,75,90}))
    I didn't think about using a constant array with index match. Thanks for teaching me something new!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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