You are creating a model that will determine the price of items for an order based on the order size. The order quantity is based on the image shown below:

The partially completed model is shown in this file.

What should be entered into cell C3 to determine the correct price based on the order quantity given in cell B1? = AnswerTABLEMAXMINFINDVLOOKUP ( Answer , Answer , Answer , AnswerFALSETRUE )

Order Quantity 74 Price Each 1 to 9 10 to 24 25 to 49 50 to 99 100 to 249 250 or more $ 11.36 $ 10.80 $ 9.19 $ 8.86 $ 8.52 $ 8.24