PLEASE HELP ME WITH QUESTIONS 6&7 AND SHOW WORK PLEASEEE!!!!!!!!! i would really appreciate it
6. Now, clear content in A12 and B12. What do you see in C12, D12, and F12? You see #N/A !!! You get this (Not Available) error because MATCH and VLOOKUP cannot find answers when the lookup value is not given. To avoid #N/A results, we put IF in front of the MATCH and VLOOKUP functions. 7. For all formulas in C12:C20, put IF in front of MATCH and we simply return 0 (zero) if no color (in Column B) is selected. Using C12 as an example: = IF (ISBLANK(B12), O, otherwise use the same MATCH as you wrote in Step #3) C12 X V fx =MATCH(B12, Color_Choice,0) A B D Order - Invoic 1 2 3 Customer Name 4 Address 5 City 6 State 7 Zip Code 8 Phone Number 9 Email Address 10 Kali Ortega 333 Sunshine Road Ewa Beach Hawaii 94010 (808) 614-9923 KallOrtega@gmail.com Color Choice 11 Product Name 12 Ramekin 13 Mesh sieve 14 Measuring cups 15 Ladle 16 Grater 17 Garlic press 18 Foil wrap 19 9" copper pot 20 12 copper skillet Black Red Yellow Green White Blue Red Yellow Black Column number based on Color Product ID 1 RAM7890 2 MES7887R 3 MEA7879Y 4 LAD7890G 6 GRA7892W 5 GAR7883B 2 FO17885R 8 COP7889Y 1 COP7882 E F G D Drder - Invoice Date: 3/15/22 Price for Quantity $11.89 Product ID 1IRAM7890 2 MES7887R 3 MEA7879Y 4 LAD7890G 6 GRA7892W 5 GAR7883B 2 FO17885R 3 COP7889Y 1 COP7882 Quantity Unit Price 1 $11.89 0 $8.89 0 $4.99 0 $7.25 0 $13.78 0 $3.99 0 $7.87 0 $55.59 0 $89.79 Subtotal Total Order ($10 is the Minimum Order) State Sales Tax Rate 7.50% State Sales Tax Shipping Charge (Waived if order exceeds $99) Invoice Total $11.89 $130 $9.75 $0.80 $140.55 6. Now, clear content in A12 and B12. What do you see in C12, D12, and F12? You see #N/A !!! You get this (Not Available) error because MATCH and VLOOKUP cannot find answers when the lookup value is not given. To avoid #N/A results, we put IF in front of the MATCH and VLOOKUP functions. 7. For all formulas in C12:C20, put IF in front of MATCH and we simply return 0 (zero) if no color (in Column B) is selected. Using C12 as an example: = IF (ISBLANK(B12), O, otherwise use the same MATCH as you wrote in Step #3) C12 X V fx =MATCH(B12, Color_Choice,0) A B D Order - Invoic 1 2 3 Customer Name 4 Address 5 City 6 State 7 Zip Code 8 Phone Number 9 Email Address 10 Kali Ortega 333 Sunshine Road Ewa Beach Hawaii 94010 (808) 614-9923 KallOrtega@gmail.com Color Choice 11 Product Name 12 Ramekin 13 Mesh sieve 14 Measuring cups 15 Ladle 16 Grater 17 Garlic press 18 Foil wrap 19 9" copper pot 20 12 copper skillet Black Red Yellow Green White Blue Red Yellow Black Column number based on Color Product ID 1 RAM7890 2 MES7887R 3 MEA7879Y 4 LAD7890G 6 GRA7892W 5 GAR7883B 2 FO17885R 8 COP7889Y 1 COP7882 E F G D Drder - Invoice Date: 3/15/22 Price for Quantity $11.89 Product ID 1IRAM7890 2 MES7887R 3 MEA7879Y 4 LAD7890G 6 GRA7892W 5 GAR7883B 2 FO17885R 3 COP7889Y 1 COP7882 Quantity Unit Price 1 $11.89 0 $8.89 0 $4.99 0 $7.25 0 $13.78 0 $3.99 0 $7.87 0 $55.59 0 $89.79 Subtotal Total Order ($10 is the Minimum Order) State Sales Tax Rate 7.50% State Sales Tax Shipping Charge (Waived if order exceeds $99) Invoice Total $11.89 $130 $9.75 $0.80 $140.55
