PLEASEE HELPP!!!! show work as well please thank you

C12 - XV fx =MATCH(B12, Color_Choice, 0) B D Order - Invoice Date: -NONSO Ortega 133 Sur Road Ewa Beach Customer Name Address City 6 State 7 Zp Code Phone Number Emil Address 10 94010 14.083 Color Choice price for Quantity $11.09 11 Product Name 12 min 19 Messive 14 Marne 15 16 17 10 Fow 100 Yellow Green w Column number based on Color Product ID RAMO MEST MAT LADY DICRATONW SIGAR FOR SCOW COP Ro Vo Quantity Unit Price 1 0 18.00 0 0 $725 0 513.78 O 33.90 57.87 0 556.50 O Subtotal Total Order ($10 is the Minimum order) State Sales Tax Rate 7.50 State Sales Tax Siping Charge (Wayed if onder exceede 596) Invece Total 21 311.89 $130 23 24 25 25 21 $0.75 SO 80 $140.55 E 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. MOOC CEDERECERREA Using C12 as an example: = IF (ISBLANK(B12), 0, otherwise use the same MATCH as you wrote in Step #3) C12 - XV fx =MATCH(B12, Color_Choice, 0) B D Order - Invoice Date: -NONSO Ortega 133 Sur Road Ewa Beach Customer Name Address City 6 State 7 Zp Code Phone Number Emil Address 10 94010 14.083 Color Choice price for Quantity $11.09 11 Product Name 12 min 19 Messive 14 Marne 15 16 17 10 Fow 100 Yellow Green w Column number based on Color Product ID RAMO MEST MAT LADY DICRATONW SIGAR FOR SCOW COP Ro Vo Quantity Unit Price 1 0 18.00 0 0 $725 0 513.78 O 33.90 57.87 0 556.50 O Subtotal Total Order ($10 is the Minimum order) State Sales Tax Rate 7.50 State Sales Tax Siping Charge (Wayed if onder exceede 596) Invece Total 21 311.89 $130 23 24 25 25 21 $0.75 SO 80 $140.55 E 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. MOOC CEDERECERREA Using C12 as an example: = IF (ISBLANK(B12), 0, otherwise use the same MATCH as you wrote in Step #3)