Hey having trouble with this problem. Instructor didnt explain it that well and Im stuck. Any help would be appreciated. Thanks

Use IF statement to calculate the expediting cost properly. The logic is that if demand is greater than order quantity, certain number of expedited orders incur. We can multiply the unit of expediting ($40) and number of expedited order to calculate the total expediting cost

\begin{tabular}{l|l|l|l|} \hline & & Range names used: \\ \hline & & Cost \\ \hline Quantity discount structure & CostLookup & \\ \hline \end{tabular}