39.1k views
0 votes
Given the following information, What is the result of =IF( B4>65, "Passing", "Failing")?

1) TRUE
2) FALSE
3) Passing
4) Failing

User Yngwaz
by
8.6k points

1 Answer

5 votes

Final answer:

The result of the formula =IF( B4>65, "Passing", "Failing") is 4) Failing.

Step-by-step explanation:

The result of the formula =IF( B4>65, "Passing", "Failing") depends on the value in cell B4.

If the value in B4 is greater than 65, the formula will return the text "Passing". If the value in B4 is less than or equal to 65, the formula will return the text "Failing".

So, the correct answer is 4) Failing.

User Anemyte
by
8.4k points