Results 1 to 9 of 9

Help with function **SOLVED**

Threaded View

  1. #1
    Registered User
    Join Date
    08-21-2011
    Location
    El Paso, TX
    MS-Off Ver
    Excel 2003
    Posts
    4

    Exclamation Help with function **SOLVED**

    So, I am trying to make my job a little easier. This may get confusing so i am going to try to make it as clear as I can.

    I have 4 cells. If the first one (A1) is less than 70 I want it to then check the next cell (A2). Again, if that one is less than 70 then I want the third cell to be checked (A3). If none are 70 and above then I want a phrase to appear in cell 4 (A4) "UNSAT". This is for testing purposes BTW.

    Now, if A1 was equal to 70 but less than 90 I want cell A4 to say "SAT". If equal to or above 90 then I want it to say "SUP".

    This would really help make things go much faster as I have 194 students that I have to process each cycle.

    So

    < 70 = UNSAT
    = or > 70 but < 90 = SAT
    and = or > 90 = SUP

    The Students get three chances to pass and that is why I need the formula to check all three cells. Also, if the first cell is 70 or above then the other two need not be checked.

    Thank you so very much. I am Semi new to excel and I have been trying to work with the IF but I cannot get it.

    Tony
    Attached Files Attached Files
    Last edited by Tonymac; 08-21-2011 at 10:36 PM.

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