Question

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

Answer 1

closed

Step-by-step explanation:

Answer 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".