Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Solve for D17 without using the IF function. Please show the formula used. begin{tabular}{|c|c|c|c|c|} hline 4 & A & B & C & D
Solve for D17 without using the IF function. Please show the formula used.
\begin{tabular}{|c|c|c|c|c|} \hline 4 & A & B & C & D \\ \hline 1 & \multicolumn{4}{|c|}{ Golf Products Order Form } \\ \hline 2 & & Shipping weight & 205 & \\ \hline 3 & & Region number & 4 & \\ \hline 4 & & Shipping Method & 3 & \\ \hline \multicolumn{5}{|l|}{5} \\ \hline 6 & Item\# & Quantity & Description & Total \\ \hline 7 & 2 & 8 & Fusion Driver - Women & $4,560.00 \\ \hline 8 & 8 & 4 & Irons w/Steel Shafts - Men & $2,200.00 \\ \hline 9 & 5 & 16 & Hybrid Woods - Men & $1,359.20 \\ \hline 10 & 16 & 3 & Package - Women & $2,100.00 \\ \hline 11 & 6 & 35 & Fusion Fairway - Women & $18,375.00 \\ \hline \multicolumn{5}{|c|}{12} \\ \hline \multicolumn{5}{|c|}{13} \\ \hline 14 & & & Total Order & $28,594.20 \\ \hline 15 & & & Shipping & 1.83 \\ \hline 16 & & & Handling & $57.19 \\ \hline 17 & & & Discount & \\ \hline 18 & & & & \\ \hline 19 & & & Grand Total & $28,653.22 \\ \hline \end{tabular} \begin{tabular}{|l|lr|lr|l|} \hline 1 & \multicolumn{2}{|l|}{ Discount } & Total Order Value & \multicolumn{1}{|c|}{ Description } \\ \hline 2 & $ & - & $ & Less than $5,000, no discount \\ \hline 3 & $ & 150 & $ & 5,000 & At least $5,000 but less than $10,000,$150 discount \\ \hline 4 & $ & 400 & $ & 10,000 & At least $10,000 but less than $50,000,$400 discount \\ \hline 5 & $ & 1,000 & $ & 50,000 & $50,000 or more, $1000 discount \\ \hline \end{tabular}Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started