Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can you please help me understand what to put in all of the IFS logical test and value boxes (all of them for all steps)?

Can you please help me understand what to put in all of the IFS logical test and value boxes (all of them for all steps)? I understand how to do the first couple based on the photo example included, but unsure about the rest. Thank you!

image text in transcribedimage text in transcribed

Classic Gardensand Landscapes Third Quarter Mailings \begin{tabular}{|c|r|r|r|} \hline Department/Group & \multicolumn{1}{|c|}{ Total Sent } & \multicolumn{1}{c|}{ Total Responses } & Response Rate \\ \hline Landscape Design & 11555 & 2824 & \\ \hline Lawn \& Maintenance & 22078 & 2847 & \\ \hline Patio \& Furniture & 14790 & 3591 & \\ \hline Total & 48,423 & 9,262 & \\ \hline \end{tabular} \begin{tabular}{|c|l|} \hline \multicolumn{2}{|c|}{ Response Rate Determination } \\ \hline>20% & Excellent \\ \hline 1520% & Very Good \\ \hline 1115% & Good \\ \hline 011% & Average \\ \hline \end{tabular} \begin{tabular}{|l|r|} \hline \multicolumn{1}{|c|}{ City } & \# of Responses \\ \hline Smyrna & 300 \\ \hline \end{tabular} 6. Create an IFS function to display a response rating. Note: If your version of Excel does not include the IFS function, build the following nested IF function =F(C7/B7>=20%,$C$15,F(C7/B7>=15%,$C$16,F(C7/B7>=11%,$C$17,$C$18))) to display the rating a. Click cell D7. The response rate and ratings are shown in rows 14:18. b. Start an IFS function and select C7 for the Logical_test1 argument. Type / for division and select cell B7. Type >=20% to complete the test. c. Click the Value_if_true1 box, select C15, and press F4 (FN+F4) (Figure 6-107). Figure 6-107 First_Logical_test and Value_if_true arguments d. Click the Logical_test2 box, select C7, type I, select cell BZ, and type >=15%. e. Click the Value_if_true2 box, click cell C16, and press F4(FN+F4). f. Complete the third and fourth logical tests and Value_if true arguments (Figure 6-108). a. Copy the formula in cell D to cells D:D10

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_2

Step: 3

blur-text-image_3

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

Essential SQLAlchemy Mapping Python To Databases

Authors: Myers, Jason Myers

2nd Edition

1491916567, 9781491916568

More Books

Students also viewed these Databases questions

Question

=+How does this metric connect to my objectives?

Answered: 1 week ago