Answered step by step
Verified Expert Solution
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!
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:D10Step 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