If purchase quantities of 25 units or higher are found to be large orders, and orders less than 25 are considered to be small, what IF function should be entered in H4 to be copied to H5:H10 to calculate each order's size? A) =IF(D4=AND=OR=25,"Large","Small") B) =IF(D425,"Small")=AND(D4=25,"Large") C) =IF(D4=25,"Large")=OR("Small") D) =IF(D4=25,"Large","Small")

Question

If purchase quantities of 25 units or higher are found to be large orders, and orders less than 25 are considered to be small, what IF function should be entered in H4 to be copied to H5:H10 to calculate each order's size?
A) =IF(D4=AND=OR=25,"Large","Small")
B) =IF(D4<>25,"Small")=AND(D4=25,"Large")
C) =IF(D4=25,"Large")=OR("Small")
D) =IF(D4>=25,"Large","Small")

Quizplus · Accepted Answer

The IF function should check whether the purchase quantity (D4) is greater than or equal to 25. If it is, the order is considered large, and if it is not, the order is small. Option D correctly uses the greater than or equal to (>=) operator to check for a purchase quantity of 25 or higher and returns "Large" if true and "Small" if false.

If Purchase Quantities of 25 Units or Higher Are Found