Results 1 to 2 of 2

Thread: Marksheet formula
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    May 2008
    Posts
    120
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Marksheet formula

    Excel 2007



    Reg: Marksheet formula


    Columns B to J are in numerical format containing marks
    obtained.



    Helper Cell K1 contains 50 in numerical format, minimum
    required marks for a "Pass".


    Columns B,C & D are category 1 and student should pass at
    least 2 subjects (out of 3)


    Columns E,F & G are category 2 and student should pass at
    least in 1 subject (out of 3)



    Columns H,I & J are category 3 and student should pass in all
    the 3 subjects (out of 3)


    So, a student is required to pass a minimum of 6 out of 9
    subjects (2 in B:D; 1 in E:G; and 3 in H:J) to qualify.



    Kindly advise me a formula to get the resultant output
    "Qualified" or else "Not Qualified".


    Thanking you,

  2. #2
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    South Western NSW
    Posts
    17,806
    Post Thanks / Like
    Mentioned
    18 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Marksheet formula

    Maybe this

    Code:
    =IF(AND(COUNTIF(B1:D1,">="&K1)>1,COUNTIF(E1:G1,">="&K1)>=1,COUNTIF(H1:J1,">="&K1)>2),"Qualified","fail")
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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