Results 1 to 7 of 7

Alternative to using multiple nested IF statements

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    11-20-2003
    MS-Off Ver
    2010, 2016
    Posts
    1,176

    Alternative to using multiple nested IF statements

    I have a spreadsheet set up as follows:

    Col A........Col B......Col C........Col D.....Col E.........Col F......Col G........Col H
    Student....Grade....Student.....Grade....Student.....Grade....Student.....Grade....
    Mike..........Pass......Tim..........Pass.......Joe............Fail.........Sue.........Pass
    Mike..........Pass......Tim..........Pass
    Mike..........Pass......Tim..........Fail
    Mike..........Pass......Tim..........Pass.......Joe............Pass........Sue.........Pass

    For each line in file, I need to determine if all students have passed the course. If all students have passed then I need to make a notation in another cell which indicates "OK". If one or more students have failed, then I need to make a notation of "Review". For example:

    Line 1 = Review
    Line 2 = Ok
    Line 3 = Review
    Line 4 = Ok

    I am trying to avoid having to write some lengthy nested if statement to solve. In some cases, I may have as many as 20 students in one line and just not sure how to test if all have passed or at least one has failed. Thanks in advance for any comments.
    Last edited by maacmaac; 09-15-2011 at 11:21 AM.

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