Question

Which function can be used as an alternate to the ‘IF’ function for elaborate test and why? Give the meaning of its types with their syntax.

Hint:

Use IFS() instead of nested IFs for clarity and to handle multiple conditions more cleanly in Excel.

Answer 1

The IFS() function in Excel is a modern replacement for nesting multiple IF statements. It evaluates multiple conditions and returns the value for the first TRUE condition.
Syntax: \[ =IFS(condition1, value1, condition2, value2, ...) \] Example: \[ \texttt{=IFS(A1<40, \"Fail\", A1<70, \"Pass\", A1>=70, \"Distinction\")} \] Why it is better than nested IFs:

• Easier to read and debug
• Avoids long and confusing nested syntax
• More efficient when handling multiple conditions

Types of conditions in IFS:

• Numerical conditions (e.g., A1 > 50)
• Text conditions (e.g., A1 = \"Yes\")
• Logical tests using operators (>, <, >=, =, etc.)