The IF function:
A)contains data for the basis of the lookup and data to be retrieved.
B)looks up a value and returns a related result from a lookup table.
C)evaluates a condition and returns one value if the condition is true,a different if false.
D)contains another function embedded inside one or more of its arguments.

Question

Quizplus · Accepted Answer

The IF function evaluates a condition and returns one value if the condition is true, a different value if the condition is false. It is commonly used in Excel to perform logical tests and make decisions based on the test results.

The IF Function