Question: What is the correct IF statement for the cost using the following condition: The cost is $ 2 0 if the order quantity is greater

What is the correct IF statement for the cost using the following condition:
The cost is $20 if the order quantity is greater than 3000.
The cost is $25 if the order quantity is between 2000 and 3000.
The cost is $30 if the order quantity is less than 2000.
Assume that the cost and the order quantity are in B9 and B5, respectively.
Question 2 options:
=IF(B9>3000,30, if(B9>=2000,25,20))
=IF(B5>3000,30, if(B5>=2000,25,20))
=IF(B5<2000,30, if(B5<=3000,25,20))
=IF(B9<2000,30, if(B9<=3000,25,20))

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!