Hello, I need help with my Excel homework I've included the information below In D16 Use the product code breakdown provided at the top of the worksheet as a guide to apply appropriate nested functions to complete the following If the product is Stainless Steel , insert the product Quantity otherwise, the cell should be blank Copy the function down to the other cells in the column In cell D14 , use the appropriate function to calculate the total from the results Format comma style, 0 decimal In E16 Use the product code breakdown provided at the top of the worksheet as a guide to apply appropriate nested functions to complete the following If the product is Black and 120 V , insert the product Price otherwise, the cell should be blank Copy the function down to the other cells in the column In cell E14 , use the appropriate function to calculate the total from the results Format comma style, 0 decimal In F16 Use the product code breakdown provided at the top of the worksheet as a guide to apply appropriate nested functions to complete the following If the product is a White , 120 V , Dishwasher , insert the product Price otherwise, the cell should be blank Copy the function down to the other cells in the column In cell F14 , use the appropriate function to calculate the total from the results Format comma style, 0 decimal In G16 Use the product code breakdown provided at the top of the worksheet as a guide to apply appropriate nested functions to complete the following If the product is a Premium , Stainless Steel , 240 V , Wall Oven , insert the product Price otherwise, the cell should be blank Copy the function down to the other cells in the column In cell G14 , use the appropriate function to calculate the total from the results Format comma style, 0 decimal In H16 Use the product code breakdown provided at the top of the worksheet as a guide to apply appropriate nested functions to complete the following If the product is a Premium , Stainless Steel or Black , Refrigerator , insert the product Price otherwise, the cell should be blank Copy the function down to the other cells in the column In cell H14 , use the appropriate function to calculate the total from the results Format comma style, 0 decimal In I16 Use the product code breakdown provided at the top of the worksheet as a guide to apply appropriate nested functions to complete the following If the product is a Black or White , 240 V , Stove or Wall Oven , insert the product Price otherwise, the cell should be blank Copy the function down to the other cells in the column In cell I14 , use the appropriate function to calculate the total from the results Format comma style, 0 decimal In J16 Use the product code breakdown provided at the top of the worksheet as a guide to apply appropriate nested functions to complete the following If the product is White or Stainless Steel , Dishwasher or Refrigerator , 120 V or Standard , insert the product Price otherwise, the cell should be blank Copy the function down to the other cells in the column In cell J14 , use the appropriate function to calculate the total from the results Format comma style, 0 decimal Alpha Numeric Product code Structure 1st character 2nd character 5th character 6th character P Premium R Refrigerator S Stainless steel 1 120 V S Standard S Stove W White 2 240 V D Dishwasher B Black M Microwave W Wall oven Top's Quality Appliances (Canada) Product code Quantity Price 1 2 3 4 5 6 7 PD41B1 428 $ 1,427 PD41S1 1,124 $ 1,819 PD41W1 1,144 $ 1,296 PD42B2 320 $ 1,440 PD42S2 1,142 $ 1,824 PD42W2 1,002 $ 1,394 PD62B1 595 $ 1,446 PD62B2 1,297 $ 1,342 PD62S1 1,455 $ 1,796 PD62S2 421 $ 1,668 PD62W1 224 $ 1,368 PD62W2 1,318 $ 1,370 PD64B1 1,120 $ 1,552 PD64B2 1,297 $ 1,519 PD64S1 177 $ 1,886 PD64S2 678 $ 1,857 PD64W1 571 $ 1,515 PD64W2 367 $ 1,453 PM11B1 483 $ 694 PM11S1 408 $ 805 PM11W1 639 $ 621 PM12B2 1,141 $ 609 PM12S2 836 $ 815 PM12W2 948 $ 633 PM59B1 893 $ 822 PM59B2 366 $ 699 PM59S1 659 $ 994 PM59S2 1,327 $ 975 PM59W1 1,366 $ 718 PM59W2 434 $ 873 PM61B1 670 $ 783 PM61B2 832 $ 717 PM61S1 964 $ 888 PM61S2 1,224 $ 937 PM61W1 845 $ 785 PM61W2 496 $ 794 PR23B1 1,283 $ 2,843 PR23B2 198 $ 2,559 PR23S1 312 $ 3,720 PR23S2 889 $ 3,560 PR23W1 1,440 $ 2,962 PR23W2 769 $ 2,876 PR26B1 574 $ 2,690 PR26B2 585 $ 3,008 PR26S1 1,275 $ 3,869 PR26S2 1,169 $ 4,090 PR26W1 1,346 $ 2,943 PR26W2 143 $ 2,881 PR61B1 193 $ 2,820 PR61S1 406 $ 4,060 PR61W1 462 $ 2,845 PR62B2 603 $ 2,729 PR62S2 473 $ 3,624 PR62W2 1,088 $ 2,808 PS31B1 351 $ 2,330 PS31S1 529 $ 3,592 PS31W1 937 $ 2,152 PS32B2 1,169 $ 2,216 PS32S2 914 $ 3,590 PS32W2 1,179 $ 2,149 PS91B1 606 $ 2,437 PS91B2 1,148 $ 2,265 PS91S1 459 $ 3,374 PS91S2 950 $ 4,104 PS91W1 224 $ 2,286 PS91W2 1,398 $ 2,457 PS93B1 1,466 $ 2,229 PS93B2 664 $ 2,324 PS93S1 584 $ 3,348 PS93S2 337 $ 3,617 PS93W1 1,401 $ 2,068 PS93W2 198 $ 2,160 PW24B1 876 $ 3,240 PW24B2 678 $ 3,449 PW24S1 963 $ 4,865 PW24S2 1,343 $ 4,625 PW24W1 1,223 $ 3,156 PW24W2 1,363 $ 3,332 PW25B1 293 $ 3,227 PW25B2 374 $ 3,201 PW25S1 166 $ 4,309 PW25S2 976 $ 4,994 PW25W1 459 $ 3,398 PW25W2 517 $ 3,628 PW51B1 481 $ 3,150 PW51S1 153 $ 4,788 PW51W1 243 $ 3,469 PW52B2 1,092 $ 3,416 PW52S2 235 $ 4,769 PW52W2 681 $ 3,151 SD31B1 951 $ 1,198 SD31S1 1,186 $ 1,310 SD31W1 398 $ 1,229 SD32B2 321 $ 1,085 SD32S2 522 $ 1,355 SD32W2 387 $ 916 SD62B1 1,325 $ 1,170 SD62B2 953 $ 1,005 SD62S1 499 $ 1,313 SD62S2 1,083 $ 1,301 SD62W1 301 $ 1,181 SD62W2 517 $ 1,046 SD63B1 1,293 $ 962 SD63B2 1,176 $ 1,247 SD63S1 1,452 $ 1,196 SD63S2 1,469 $ 1,316 SD63W1 1,370 $ 1,312 SD63W2 894 $ 1,219 SM11B1 732 $ 703 SM11S1 1,100 $ 729 SM11W1 120 $ 466 SM12B2 354 $ 626 SM12S2 503 $ 650 SM12W2 1,287 $ 637 SM59B1 656 $ 605 SM59B2 1,381 $ 507 SM59S1 364 $ 565 SM59S2 1,439 $ 598 SM59W1 193 $ 470 SM59W2 480 $ 520 SM61B1 623 $ 599 SM61B2 1,052 $ 719 SM61S1 886 $ 634 SM61S2 289 $ 621 SM61W1 475 $ 736 SM61W2 473 $ 668 SR23B1 726 $ 2,091 SR23B2 1,220 $ 2,055 SR23S1 696 $ 2,221 SR23S2 232 $ 2,090 SR23W1 1,286 $ 1,850 SR23W2 332 $ 2,341 SR25B1 302 $ 2,046 SR25B2 742 $ 1,997 SR25S1 268 $ 2,151 SR25S2 1,260 $ 2,141 SR25W1 971 $ 2,300 SR25W2 276 $ 1,908 SR51B1 344 $ 2,128 SR51S1 752 $ 2,160 SR51W1 949 $ 1,878 SR52B2 401 $ 2,160 SR52S2 839 $ 1,991 SR52W2 640 $ 1,979 SS31B1 362 $ 1,845 SS31S1 837 $ 1,914 SS31W1 509 $ 1,589 SS32B2 460 $ 1,571 SS32S2 921 $ 1,653 SS32W2 748 $ 1,621 SS91B1 962 $ 1,578 SS91B2 1,387 $ 1,831 SS91S1 1,159 $ 2,079 SS91S2 222 $ 1,960 SS91W1 296 $ 1,690 SS91W2 291 $ 1,746 SS93B1 829 $ 1,794 SS93B2 424 $ 1,742 SS93S1 639 $ 1,715 SS93S2 494 $ 1,533 SS93W1 272 $ 1,774 SS93W2 180 $ 1,872 SW24B1 1,146 $ 2,737 SW24B2 988 $ 2,835 SW24S1 763 $ 3,348 SW24S2 186 $ 2,931 SW24W1 1,035 $ 2,743 SW24W2 1,015 $ 3,074 SW26B1 1,351 $ 2,881 SW26B2 664 $ 2,894 SW26S1 956 $ 2,815 SW26S2 918 $ 3,312 SW26W1 1,073 $ 2,736 SW26W2 691 $ 2,850 SW61B1 467 $ 2,757 SW61S1 720 $ 3,053 SW61W1 459 $ 3,042 SW62B2 390 $ 2,989 SW62S2 1,082 $ 2,691 SW62W2 1,249 $ 2,712

The Answer is in the image, click to view ...

Question: Hello, I need help with my Excel homework. I've included the information below. In D16 : Use the product code breakdown provided at the top

Hello, I need help with my Excel homework. I've included the information below. In D16: Use the product code breakdown provided at the top of the worksheet as a guide to apply appropriate nested functions to complete the following:

If the product is Stainless Steel, insert the product Quantity; otherwise, the cell should be blank. Copy the function down to the other cells in the column.

In cell D14, use the appropriate function to calculate the total from the results. Format comma style, 0 decimal.

In E16: Use the product code breakdown provided at the top of the worksheet as a guide to apply appropriate nested functions to complete the following:

If the product is Black and 120 V, insert the product Price; otherwise, the cell should be blank. Copy the function down to the other cells in the column.

In cell E14, use the appropriate function to calculate the total from the results. Format comma style, 0 decimal.

In F16: Use the product code breakdown provided at the top of the worksheet as a guide to apply appropriate nested functions to complete the following:

If the product is a White, 120 V, Dishwasher, insert the product Price; otherwise, the cell should be blank. Copy the function down to the other cells in the column.

In cell F14, use the appropriate function to calculate the total from the results. Format comma style, 0 decimal.

In G16: Use the product code breakdown provided at the top of the worksheet as a guide to apply appropriate nested functions to complete the following:

If the product is a Premium, Stainless Steel, 240 V, Wall Oven, insert the product Price; otherwise, the cell should be blank. Copy the function down to the other cells in the column.

In cell G14, use the appropriate function to calculate the total from the results. Format comma style, 0 decimal.

In H16: Use the product code breakdown provided at the top of the worksheet as a guide to apply appropriate nested functions to complete the following:

If the product is a Premium, Stainless Steel or Black, Refrigerator, insert the product Price; otherwise, the cell should be blank. Copy the function down to the other cells in the column.

In cell H14, use the appropriate function to calculate the total from the results. Format comma style, 0 decimal.

In I16: Use the product code breakdown provided at the top of the worksheet as a guide to apply appropriate nested functions to complete the following:

If the product is a Black or White, 240 V, Stove or Wall Oven, insert the product Price; otherwise, the cell should be blank. Copy the function down to the other cells in the column.

In cell I14, use the appropriate function to calculate the total from the results. Format comma style, 0 decimal.

In J16: Use the product code breakdown provided at the top of the worksheet as a guide to apply appropriate nested functions to complete the following:

If the product is White or Stainless Steel, Dishwasher or Refrigerator, 120 V or Standard, insert the product Price; otherwise, the cell should be blank. Copy the function down to the other cells in the column.

In cell J14, use the appropriate function to calculate the total from the results. Format comma style, 0 decimal.

			Alpha Numeric Product code Structure
			1st character	2nd character	5th character	6th character
			P	Premium	R	Refrigerator	S	Stainless steel	1	120 V
			S	Standard	S	Stove	W	White	2	240 V
					D	Dishwasher	B	Black
					M	Microwave
					W	Wall oven


Top's Quality Appliances (Canada)




Product code	Quantity	Price	1	2	3	4	5	6	7
PD41B1	428	$ 1,427
PD41S1	1,124	$ 1,819
PD41W1	1,144	$ 1,296
PD42B2	320	$ 1,440
PD42S2	1,142	$ 1,824
PD42W2	1,002	$ 1,394
PD62B1	595	$ 1,446
PD62B2	1,297	$ 1,342
PD62S1	1,455	$ 1,796
PD62S2	421	$ 1,668
PD62W1	224	$ 1,368
PD62W2	1,318	$ 1,370
PD64B1	1,120	$ 1,552
PD64B2	1,297	$ 1,519
PD64S1	177	$ 1,886
PD64S2	678	$ 1,857
PD64W1	571	$ 1,515
PD64W2	367	$ 1,453
PM11B1	483	$ 694
PM11S1	408	$ 805
PM11W1	639	$ 621
PM12B2	1,141	$ 609
PM12S2	836	$ 815
PM12W2	948	$ 633
PM59B1	893	$ 822
PM59B2	366	$ 699
PM59S1	659	$ 994
PM59S2	1,327	$ 975
PM59W1	1,366	$ 718
PM59W2	434	$ 873
PM61B1	670	$ 783
PM61B2	832	$ 717
PM61S1	964	$ 888
PM61S2	1,224	$ 937
PM61W1	845	$ 785
PM61W2	496	$ 794
PR23B1	1,283	$ 2,843
PR23B2	198	$ 2,559
PR23S1	312	$ 3,720
PR23S2	889	$ 3,560
PR23W1	1,440	$ 2,962
PR23W2	769	$ 2,876
PR26B1	574	$ 2,690
PR26B2	585	$ 3,008
PR26S1	1,275	$ 3,869
PR26S2	1,169	$ 4,090
PR26W1	1,346	$ 2,943
PR26W2	143	$ 2,881
PR61B1	193	$ 2,820
PR61S1	406	$ 4,060
PR61W1	462	$ 2,845
PR62B2	603	$ 2,729
PR62S2	473	$ 3,624
PR62W2	1,088	$ 2,808
PS31B1	351	$ 2,330
PS31S1	529	$ 3,592
PS31W1	937	$ 2,152
PS32B2	1,169	$ 2,216
PS32S2	914	$ 3,590
PS32W2	1,179	$ 2,149
PS91B1	606	$ 2,437
PS91B2	1,148	$ 2,265
PS91S1	459	$ 3,374
PS91S2	950	$ 4,104
PS91W1	224	$ 2,286
PS91W2	1,398	$ 2,457
PS93B1	1,466	$ 2,229
PS93B2	664	$ 2,324
PS93S1	584	$ 3,348
PS93S2	337	$ 3,617
PS93W1	1,401	$ 2,068
PS93W2	198	$ 2,160
PW24B1	876	$ 3,240
PW24B2	678	$ 3,449
PW24S1	963	$ 4,865
PW24S2	1,343	$ 4,625
PW24W1	1,223	$ 3,156
PW24W2	1,363	$ 3,332
PW25B1	293	$ 3,227
PW25B2	374	$ 3,201
PW25S1	166	$ 4,309
PW25S2	976	$ 4,994
PW25W1	459	$ 3,398
PW25W2	517	$ 3,628
PW51B1	481	$ 3,150
PW51S1	153	$ 4,788
PW51W1	243	$ 3,469
PW52B2	1,092	$ 3,416
PW52S2	235	$ 4,769
PW52W2	681	$ 3,151
SD31B1	951	$ 1,198
SD31S1	1,186	$ 1,310
SD31W1	398	$ 1,229
SD32B2	321	$ 1,085
SD32S2	522	$ 1,355
SD32W2	387	$ 916
SD62B1	1,325	$ 1,170
SD62B2	953	$ 1,005
SD62S1	499	$ 1,313
SD62S2	1,083	$ 1,301
SD62W1	301	$ 1,181
SD62W2	517	$ 1,046
SD63B1	1,293	$ 962
SD63B2	1,176	$ 1,247
SD63S1	1,452	$ 1,196
SD63S2	1,469	$ 1,316
SD63W1	1,370	$ 1,312
SD63W2	894	$ 1,219
SM11B1	732	$ 703
SM11S1	1,100	$ 729
SM11W1	120	$ 466
SM12B2	354	$ 626
SM12S2	503	$ 650
SM12W2	1,287	$ 637
SM59B1	656	$ 605
SM59B2	1,381	$ 507
SM59S1	364	$ 565
SM59S2	1,439	$ 598
SM59W1	193	$ 470
SM59W2	480	$ 520
SM61B1	623	$ 599
SM61B2	1,052	$ 719
SM61S1	886	$ 634
SM61S2	289	$ 621
SM61W1	475	$ 736
SM61W2	473	$ 668
SR23B1	726	$ 2,091
SR23B2	1,220	$ 2,055
SR23S1	696	$ 2,221
SR23S2	232	$ 2,090
SR23W1	1,286	$ 1,850
SR23W2	332	$ 2,341
SR25B1	302	$ 2,046
SR25B2	742	$ 1,997
SR25S1	268	$ 2,151
SR25S2	1,260	$ 2,141
SR25W1	971	$ 2,300
SR25W2	276	$ 1,908
SR51B1	344	$ 2,128
SR51S1	752	$ 2,160
SR51W1	949	$ 1,878
SR52B2	401	$ 2,160
SR52S2	839	$ 1,991
SR52W2	640	$ 1,979
SS31B1	362	$ 1,845
SS31S1	837	$ 1,914
SS31W1	509	$ 1,589
SS32B2	460	$ 1,571
SS32S2	921	$ 1,653
SS32W2	748	$ 1,621
SS91B1	962	$ 1,578
SS91B2	1,387	$ 1,831
SS91S1	1,159	$ 2,079
SS91S2	222	$ 1,960
SS91W1	296	$ 1,690
SS91W2	291	$ 1,746
SS93B1	829	$ 1,794
SS93B2	424	$ 1,742
SS93S1	639	$ 1,715
SS93S2	494	$ 1,533
SS93W1	272	$ 1,774
SS93W2	180	$ 1,872
SW24B1	1,146	$ 2,737
SW24B2	988	$ 2,835
SW24S1	763	$ 3,348
SW24S2	186	$ 2,931
SW24W1	1,035	$ 2,743
SW24W2	1,015	$ 3,074
SW26B1	1,351	$ 2,881
SW26B2	664	$ 2,894
SW26S1	956	$ 2,815
SW26S2	918	$ 3,312
SW26W1	1,073	$ 2,736
SW26W2	691	$ 2,850
SW61B1	467	$ 2,757
SW61S1	720	$ 3,053
SW61W1	459	$ 3,042
SW62B2	390	$ 2,989
SW62S2	1,082	$ 2,691
SW62W2	1,249	$ 2,712

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

For Problem 4.4.10, use computer software and the Hazen-Williams equation instead of the DarcyWeisbach equation to solve for the flows. Problem 4.4.10 Using computer software, determine the flow rate...

Accounting Homework question rephrased/reformatted for clarification. Hello, I need help completing the following homework assignment: Record the daily transactions if appropriate, (some events do...

Hello, I need help with this Excel assignment. It involves the use of what if analysis. Capital Budgeting - Cott Corpo Suppose that the Cott Corporation (COT) is considering adding a new product...

please HELPPP!!! ex C Get Homework Help With Che X + haida7370318 chapterid=63462 Samance Commu. Business cards - Fountain Writers Work Wil Motley Fool Williams Tax Service Profile - Investing- BD...

hello got to fill out schedule k for Jim corporation 2011 Instructions for Form 1120 Department of the Treasury Internal Revenue Service U.S. Corporation Income Tax Return Section references are to...

Hello please refer to part 4 from the question paper I have attached the past student work for your reference just have to follow the format if you feel comfortable with I have attached the necessary...

BATCH 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67...

P L U G - I N T3 Problem Solving Using Excel 2010 LEARN IN G OUT C O ME S 1. 2. 3. 4. 5. Describe how to create and sort a list using Excel. Explain why you would use conditional formatting using...

Find the equation for the plane tangent to eachsurface z = f ( x , y )at the indicated point. (a) z = x 3 + y 3 ? 5 xy ,at the point (1, 2, 1) (b) z = (cos( x ))(cos( y )), at the point (0, ?/2,0)...

Your neighbor is buying a new recreational vehicle (RV). He has the following options to finance the RV: I. Pays $60,000 today (in time 0). II. Buy under a "no payments for three years" program by...

Traditional format income statements: multiple choice 1 Use the term contribution margin rather than gross margin. Report variable selling expenses separate from fixed selling expenses. Organize...

In Medical Sociology, we see that African-American males tend to live somewhat shorter lives than their male counterparts in various races. Based on researchers, what are some factors that may...