Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Posts
    9

    Unanswered: Excel help wanted :)

    Hey does anyone know the formula to do this.

    I have 2 columns with student marks in called "exam mark" and "coursework mark", if they fall below 40 then they fail that module and are entitled to a resit. I have a third column called resits. I need a formula to determine what modules were failed and display them like so. "None", "Exam", "Coursework", "Both"

    Im stuck Ive been working with nested IF statements......but am only confuesing myself.....anyone care to help..much appreciated.

    Thanks!

  2. #2
    Join Date
    Sep 2003
    Location
    Cincinnati, Oh USA
    Posts
    203

    Re: Excel help wanted :)

    More info needed. Is the grade in the exam column and could the user appear more than once in that column?

    Originally posted by bigdavestar
    Hey does anyone know the formula to do this.

    I have 2 columns with student marks in called "exam mark" and "coursework mark", if they fall below 40 then they fail that module and are entitled to a resit. I have a third column called resits. I need a formula to determine what modules were failed and display them like so. "None", "Exam", "Coursework", "Both"

    Im stuck Ive been working with nested IF statements......but am only confuesing myself.....anyone care to help..much appreciated.

    Thanks!
    Rick Knight
    KnightShift Office Solutions and Horse Breaking
    VB, VBA, FileMaker, Access Solutions, Web Solutions

  3. #3
    Join Date
    Dec 2003
    Location
    San Diego, CA
    Posts
    153
    Welcome to the Board!

    Maybe you can attach a sample of your worksheet.

    Smitty

  4. #4
    Join Date
    Feb 2004
    Location
    USA - California
    Posts
    21

    Re: Excel help wanted :)

    Originally posted by bigdavestar
    Hey does anyone know the formula to do this.

    I have 2 columns with student marks in called "exam mark" and "coursework mark", if they fall below 40 then they fail that module and are entitled to a resit. I have a third column called resits. I need a formula to determine what modules were failed and display them like so. "None", "Exam", "Coursework", "Both"

    Im stuck Ive been working with nested IF statements......but am only confuesing myself.....anyone care to help..much appreciated.

    Thanks!

    Hi Dave
    If Exam Scores are in column D, and Coursework in Column E and resits in F beginning at row 6, for example, then try this:
    =IF(AND(D6<40,E6<40),"Both",IF(D6<40,"Exam",IF(E6< 40,"Coursework","None")))
    Melinda

Posting Permissions

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