What would I put as a nested IF function formula for The first top grey box under Qty Discount Price

10.) Steelpin, Inc. wants to implement a Quantity Discount Program for it customers. If the order quantity is =100 and =500, the priced is discounted 10%, as indicated in the table below. Using cell references (no hardcoding), and nested IF statements, create a formula that determines the correct price to charge for each of the 3 orders below based on the order quantity. \begin{tabular}{|c|c|c|c|c|c|c|} \hline Minimum Qty & Discount & & & & & \\ \hline 100 & 5% & & & & & \\ \hline 500 & 10% & & & & & \\ \hline Supplier & Order No. & Item No. & Item Description & Regular Price & Order Quantity & QtyDiscountPrice \\ \hline Steelpin Inc. & Aug11007 & 4312 & Bolt-nut package & $10.00 & 50 & \\ \hline Steelpin Inc. & Sep11001 & 4312 & Bolt-nut package & $10.00 & 281 & \\ \hline Steelpin Inc. & Sep11005 & 4312 & Bolt-nut package & $10.00 & 738 & \\ \hline \end{tabular} Note these 3 lines will test all three price points