The three parts of an IIF function are separated by ________. A. dashes B. asterisks C. semicolons D. commas

The correct answer is: D. commas

The IIF function is a logical function that returns one value if a condition is true, and another value if the condition is false. The three parts of an IIF function are:

• The condition
• The value to return if the condition is true
• The value to return if the condition is false

The three parts of an IIF function are separated by commas. For example, the following IIF function returns “Yes” if the value in cell A1 is greater than 10, and “No” if the value is less than or equal to 10:

=IIF(A1>10, “Yes”, “No”)

The other options are incorrect because they are not valid separators for the IIF function. Dashes (-), asterisks (*), and semicolons (;) are not valid separators for the IIF function.