and
1 sub-question across 1 paper, 6 marks total.
Computer Applications Technology 2026
In J4, use a nested IF function together with AND to display 'Flag' if Attendance is 120 or more AND Satisfaction is 4.5 or more. Leave blank if both criteria are not met. Autofill to J15.
Satisfaction is assumed to be column F here.
Show answerHide answer
Attendance is column E. Satisfaction is assumed to be column F here. Check your header row for the real column.
A form with an explicit second IF (still "nested") gives the same result:
Type the formula in J4 and press Enter.
Drag the fill handle from J4 down to J15 (or double-click it).
J4: =IF(AND(E4>=120,F4>=4.5),"Flag","")J4: =IF(AND(E4>=120,F4>=4.5),"Flag","")=IF(E4>=120,IF(F4>=4.5,"Flag",""),"")=IF(E4>=120,IF(F4>=4.5,"Flag",""),"")Why this earns the marks
six marks: IF used, AND used, attendance test with >=, satisfaction test with >=, "Flag" as the true result and "" (blank) as the false result, plus the fill to J15 — six independently checkable pieces nested inside one formula. Use >=, not >, because "120 or more" includes 120: a strict greater-than would wrongly exclude a row where attendance is exactly 120, which the wording explicitly includes. The empty quotes "" make the cell appear blank, which is different from leaving the formula's false branch empty entirely (that would be a syntax error) — "" is Excel's way of writing "the text value containing zero characters," which displays as nothing while still being a valid, present formula result. Relative references (no $) let each row test its own values when copied down: with no dollar signs, E4 and F4 automatically become E5/F5, E6/F6 and so on as the formula fills downward, exactly like any ordinary relative reference.