What is the function of the IF function in Excel?
- A. To perform a logical test and return a value based on the result
- B. To add up a range of cells
- C. To find the average of a range of cells
- D. To count the number of cells in a range
Explanation
IF evaluates a logical condition and returns one result when the condition is true and another when it is false. SUM, AVERAGE, and COUNT perform the other listed calculation types.