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
Bookmarks