Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribedimage text in transcribed \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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Development Of A Methodology For Customizing Insider Threat Auditing On A Linux Operating System

Authors: William T. Bai, Air Force Institute Of Technology (U.S.)

1st Edition

1249449847, 978-1249449843

More Books

Students also viewed these Accounting questions

Question

The models used to analyse different national cultures.

Answered: 1 week ago

Question

The nature of the issues associated with expatriate employment.

Answered: 1 week ago