Answer to Question #276481 in Excel for Ttyyyy

Question

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).

Answer 1

The answer to your question is provided in the image: