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

Event Analysis Action Bonus EventID EVNT-0037 EVNT-0012 EVNT-0042 EVNT-0022 EVNT-0017 EVNT-0032 EventType TotalRegistrants Annual Conference 23 Peer Networking 66 Plant Tour 27 Plant Tour 38 Peer Networking 21 Survey/Study 24 Registration Goals EventID Registration Goal EVNT-0037 20 EVNT-0012 70 EVNT-0042 25 EVNT-0022 40 EVNT-0017 20 EVNT-0032 25 Annual Conference $ Peer Networking $ Plant Tour $ Survey/Study $ Goal Met 20 25 30 35 40 150.00 $170.00 $190.00 $210.00 $ 230.00 140.00 $160.00 $180.00 $200.00 $220.00 160.00 $180.00 $200.00 $220.00 $240.00 120.00 $140.00 $160.00 $180.00 $200.00 Annual Conference $ Peer Networking $ Plant Tour $ Survey/Study $ Promote Event 20 25 30 35 40 100.00 $120.00 $140.00 $ 160.00 $ 180.00 90.00 $110.00 $130.00 $ 150.00 $170.00 110.00 $130.00 $ 150.00 $170.00 $190.00 70.00 $ 90.00 $110.00 $130.00 $ 150.00 Event Analysis Action Bonus EventID EVNT-0037 EVNT-0012 EVNT-0042 EVNT-0022 EVNT-0017 EVNT-0032 EventType TotalRegistrants Annual Conference 23 Peer Networking 66 Plant Tour 27 Plant Tour 38 Peer Networking 21 Survey/Study 24 Registration Goals EventID Registration Goal EVNT-0037 20 EVNT-0012 70 EVNT-0042 25 EVNT-0022 40 EVNT-0017 20 EVNT-0032 25 Annual Conference $ Peer Networking $ Plant Tour $ Survey/Study $ Goal Met 20 25 30 35 40 150.00 $170.00 $190.00 $210.00 $ 230.00 140.00 $160.00 $180.00 $200.00 $220.00 160.00 $180.00 $200.00 $220.00 $240.00 120.00 $140.00 $160.00 $180.00 $200.00 Annual Conference $ Peer Networking $ Plant Tour $ Survey/Study $ Promote Event 20 25 30 35 40 100.00 $120.00 $140.00 $ 160.00 $ 180.00 90.00 $110.00 $130.00 $ 150.00 $170.00 110.00 $130.00 $ 150.00 $170.00 $190.00 70.00 $ 90.00 $110.00 $130.00 $ 150.00