Ask Question
14 December, 00:45

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

+4
Answers (1)
  1. 14 December, 01:50
    0
    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".
Know the Answer?
Not Sure About the Answer?
Get an answer to your 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 ...” in 📙 Computers & Technology if there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers