Students NamesInt1 MarksInt2 MarksInt3 MarksFinal ICAStatusScore of 100Mpho Tau5010090Neo Kou1001030Dee Maps203525Dkay Reed1004585Thabo Koloi506530Thato Khahloe10010090
Use the “IF” function to assign students a Status based on the following; Proceed (if final ICA is 50 or more), Supplement (if final ICA is between 30 and 49) or Retake (if final ICA is 29 or less).
The answer to your question is provided in the image:
Comments
Leave a comment