Which IF formula returns 35000 when B9 is greater than or equal to 470000, otherwise returns 100?

Which IF formula returns 35000 when B9 is greater than or equal to 470000, otherwise returns 100?

• A. =IF(B9>470000, 35000, 100)
• B. =IF(B9>=470000, 100, 35000)
• C. =IF(B9>=470000, 35000, 0)
• D. =IF(B9>=470000, 35000, 100)

Answer: (D)

Understanding how IF works is key: IF takes a condition, a result if true, and a result if false. Here you want 35000 when B9 is at least 470000, and 100 otherwise. So you test B9 >= 470000; if that is true, you return 35000, else you return 100. The formula that does this exactly is =IF(B9>=470000, 35000, 100). Why the other forms don’t fit: using > instead of >= would fail when B9 equals 470000. swapping the true/false results would give 100 when the condition is met and 35000 when it isn’t. using 0 as the false result would return 0 in the false case, not 100. This one keeps the true result of 35000 and the false result of 100.

Understanding how IF works is key: IF takes a condition, a result if true, and a result if false. Here you want 35000 when B9 is at least 470000, and 100 otherwise. So you test B9 >= 470000; if that is true, you return 35000, else you return 100. The formula that does this exactly is =IF(B9>=470000, 35000, 100).

Why the other forms don’t fit: using > instead of >= would fail when B9 equals 470000. swapping the true/false results would give 100 when the condition is met and 35000 when it isn’t. using 0 as the false result would return 0 in the false case, not 100. This one keeps the true result of 35000 and the false result of 100.