Answer-What does the IF function do in Excel?

The IF function in Excel tests a condition and returns one value if the condition is true and another value if the condition is false.

Question

What does the IF function do in Excel?

A Performs arithmetic calculations on a range of cells

B Tests a condition and returns one value if the condition is true and another value if the condition is false

C Finds the highest value in a range of cells

D Counts the number of cells in a range that meet specified criteria

E None of these