In cell M11, enter a formula that will calculate the total amount due after discounts have been applied. Incorporate an IFERROR function to return a blank value ("") if formula returns an error. Format the result as Accounting and copy the formula down through M34.

C D E F G H L M A B 1 Client Registrations 2 3 4 5 6 7 8 9 9 Board Member Discounts Discount EventType 5% Annual Conference 5% Peer Networking 7% Plant Tour 10% Survey/Study Amount Due Guests Friends Discount 39 Board Member Yes Yes Yes 10 11 12 13 12 14 14 15 15 16 17 17 10 18 10 19 20 20 21 39 22 30 3% Yes ContactID Firstname CN-0001 Charity CN-0003 Justin CN-0004 Sydnee CALOost CN-0005 Blake CN-0006 Christine CN-0007 Cassidy CN-0008 Sloane CM 2004 CN-00010 Wing 004 CN-00011 Avram CM 200 den CN-00012 Adena Noterat CN-00013 Barrett Colic CN-00014 Angelica CN-00015 Christine CM nach CN-00016 Kevyn CN-00020 Heidi CN-00022 Rebecca CN-00023 Josephine CN-00025 Fiona CN-00026 Jeremy CN-00027 Dora Lastname Calhoun Wallace Washington Bryan Tyson Lowe Shaffer Oneil Conrad Henry Gonzales - Marquez Hughes Lara Ecte Estes Greene Henson Oneil Sullivan Delacruz Company Name SEA-LECT Plastics Corporation SMT LLC Southern Indiana Plastics Southwest Mold Inc. SPI Industries Inc. Steinwalline Steinwall Inc. Stihl Incorporated Tasus Corporation - Alabama Tasus Corporation - Texas Team 1 Plastics Technical Industries Inc. Thogus Products Company Trademark Plastics Inc. Treemen Industries Inc Mante Vantec Inc. Venture Plastics Wabash Plastics Inc. GTM Plastics Inc. GTR Enterprises Hansen Plastics Corporation Date Registered 11-Jan-19 17-Dec-18 16-Feb-18 00 B 09-Feb-19 021 07-Apr-19 Mo 30-Mar-18 23-Jul-19 1700 17-Feb-18 OEM 05-May-18 22 22-Aug-18 01-Apr-18 01.18 01-Nov-18 101 14-Jun-19 -- 240 21-Jul-18 28-Nov-19 24-May-18 01-Jul-18 04-Feb-18 22-Jun-18 EventID EVNT-0037 EVNT-0037 EVNT-0012 INTRO EVNT-0037 IT046 EVNT-0042 INC EVNT-0022 DE 2003 EVNT-0022 UNIT EVNT-0042 FUNT EVNT-0017 EVNT-0022 PUNT.2013 EVNT-0012 EVNT-0037 2002 EVNT-0037 EVNT. EVNT-0032 EVNT-0017 EVNT-0022 - EVNT-0032 EVNT-0012 EVNT-0032 EVNT-0022 Registration Fees 3 $ 360.00 1 $ 120.00 2 $ 360.00 to 10000 1 $ 120.00 to FO 2 $ 500.00 to 100 1 $ 190.00 are 5 $ 950.00 to so 1 $ 250.00 40 1 $ 110.00 2010 to 3 $ 570.00 to no 2 $ 360.00 ts 1901 1 $ 120.00 10000 1 $ 120.00 to 200 3 $ 540.00 1 $ 110.00 1 $ 190.00 1 $ 180.00 3 $ 540.00 2 $ 360.00 1 $ 190.00 r Event Discount Discount 5% TRUE TRUE TRUE TRUE TOUE 5% TRUE FOUR 7% TRUE COUP TRUE -OUE TRUE COUP 7% TRUE Folle TRUE TRUE TRUE 5% TRUE TRUE TRUE 5% 5 5% TRUE TRUE 5% Yes 10-Mar-18! Yes Yes 5% TRUE 3% 5% 24 25 26 27 28 29 30 31 32 33 34 35 36 TRUE