Which of the Following Is NOT True Regarding Nested IIf

question 4

Multiple Choice

Which of the following is NOT true regarding nested IIf functions?

• A)You can create a nested IIf function,allowing you to evaluate a series of dependent expressions.
• B)A nested IIf function is used when you need to test for multiple conditions.
• C)When having one IIf function nested inside another,the second IIf function becomes the truepart of the first IIf function.
• D)When having one IIf function nested inside another,the second IIf function becomes the falsepart of the first IIf function.

---

Definitions:

Commission Rate

The percentage or fixed payment associated with a transaction, often used in sales to determine the amount paid to the salesperson or agent.

Gross Earnings

The total amount of money an individual or company makes before any deductions are made.

Weekly Base Salary

The amount of money an employee is paid each week before any deductions or taxes.

Commission

A fee paid for services, usually a percentage of the total cost, to a salesperson or agent for facilitating a sale or transaction.