To perform the task of displaying "credit approved" or "credit denied" based on the corresponding Boolean value in column H, you can write a formula in cell I3 containing an IF function, as follows: ____.
A) =IF(H3,"credit approved","credit denied")
B) =IF(H3,"credit denied","credit denied")
C) =IF("credit denied","credit denied",H3)
D) =IF H3 ("credit denied","credit denied")

Question

Quizplus · Accepted Answer

The IF function takes a logical test as its first argument, which in this case is the Boolean value in cell H3. If H3 is true (i.e., the credit is approved), the formula returns the text "credit approved." If H3 is false (i.e., the credit is denied), the formula returns the text "credit denied." Option B always returns "credit denied" regardless of the value in cell H3. Option C mixes up the order of arguments in the IF function, and option D has a syntax error because it lacks parentheses around the logical test.

To Perform the Task of Displaying "Credit Approved" or "Credit