PLEASEEEEE HELP ME WITH 6 & 7 SHOW WORK PLEASE!!!

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) fx =MATCH(B12, Color_Choice,0) D Order - Invoice E F Date: Kall Ortega 333 Sunshine Road Ewa Beach Hawa Customer Name 4 Address 5 City 6 State 7 Zip Code 8 Phone Number . Email Address 10 94010 (08) 614.923 Carregamall.com Color Choice Quantity 1 0 0 0 Column number based on color Product ID RAM MESTER 3 MEA78297 4 LADOG SCRATE92 S GAR78838 2 FOISOR 3 COPY 1.COM 11 Product Name 12 Ramki 13 Messive 14 Measuring cup 15 de 16 ore 17 Garters 18 Fol 10 corpo 2012 corsi 21 22 Red Yellow Gro w B Rad Yellow 0 Unit Price $11.89 $8.89 $4.99 5725 $13.78 $3.99 $7.87 555 59 $89.79 Subtotal Total Order ($10 is the Minimum Order) 0 0 0 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) fx =MATCH(B12, Color_Choice,0) D Order - Invoice E F Date: Kall Ortega 333 Sunshine Road Ewa Beach Hawa Customer Name 4 Address 5 City 6 State 7 Zip Code 8 Phone Number . Email Address 10 94010 (08) 614.923 Carregamall.com Color Choice Quantity 1 0 0 0 Column number based on color Product ID RAM MESTER 3 MEA78297 4 LADOG SCRATE92 S GAR78838 2 FOISOR 3 COPY 1.COM 11 Product Name 12 Ramki 13 Messive 14 Measuring cup 15 de 16 ore 17 Garters 18 Fol 10 corpo 2012 corsi 21 22 Red Yellow Gro w B Rad Yellow 0 Unit Price $11.89 $8.89 $4.99 5725 $13.78 $3.99 $7.87 555 59 $89.79 Subtotal Total Order ($10 is the Minimum Order) 0 0 0