14. If B3=10 and D5=8, what would the following function return? IF (B3>D5, "Closed", D5-B3) *

A. "Open"

B. "Closed"

C. - 2

D. + 2

IF function has three parts

IF (condition_to_check, return_if_true, return_if_false)

IF function first checks condition. If it is true it returns first result. Otherwise it returns second result.

Condition to check:

B3>D5

After inserting numbers we get:

10>8

This is correct so the first result will be returned.

The given IF function returns "Closed".