Spreadsheet

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

The ROUND function in Excel helps eliminate unwanted decimal places. The syntax is: Explanation:

• If num\_digits = 0, it rounds to the nearest integer.
• If positive, rounds to that number of decimal places.
• If negative, rounds to left of the decimal (e.g., nearest 10, 100).

Example: