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 Details EventType Registration Fee EventID EventName 2019 Benchmarking Conference EVNT-0037 Attendee EVNT-0012 January HR Peer Networking EVNT-0042 Toyota Plant Tour EVNT-0022 Marsh Bellofram Plant Tour EVNT-0017 Human Resource Professionals EVNT-0032 State of the Industry Annual Conference $ Peer Networking $ Plant Tour $ Plant Tour $ Peer Networking $ Survey/Study $ 120.00 180.00 250.00 190.00 110.00 180.00 1 2 M11 X fic E F G H I J K L M N 8 9 Event Friends Amount Due Guests Discount 3% 3 1 2 1 1 2 1 Board Membe Registration Fees Discount 360 5% 120 360 120 #N/A 500 #N/A 190 950 250 #N/A 110 570 360 #N/A 10 Company Name 11 SEA-LECT Plastics Corporation 12 SMT LLC 13 Southern Indiana Plastics 14 Southwest Mold Inc. 15 SPI Industries Inc. 16 Steinwall Inc. 17 Stihl Incorporated 18 Tasus Corporation - Alabama 19 Tasus Corporation - Texas 20 Team 1 Plastics 21 Technical Industries Inc. 22 Thogus Products Company 23 Trademark Plastics Inc. 24 Treemen Industries Inc 25 Vantec Inc. 26 Venture Plastics 27 Wabash Plastics Inc. 28 GTM Plastics Inc. 29 GTR Enterprises 30 Hansen Plastics Corporation 31 32 DateRegistered 11-Jan-19 17-Dec-18 16-Feb-18 09-Feb-19 07-Apr-19 30-Mar-18 23-Jul-19 17-Feb-18 05-May-18 22-Aug-18 01-Apr-18 01-Nov-18 14-Jun-19 10-Mar-18 21-Jul-18 28-Nov-19 24-May-18 01-Jul-18 04-Feb-18 22-Jun-18 3% EventID EVNT-0037 EVNT-0037 EVNT-0012 EVNT-0037 EVNT-0042 EVNT-0022 EVNT-0022 EVNT-0042 EVNT-0017 EVNT-0022 EVNT-0012 EVNT-0037 EVNT-0037 EVNT-0032 EVNT-0017 EVNT-0022 EVNT-0032 EVNT-0012 EVNT-0032 EVNT-0022 Discount 5% 5% 5% 5% 5% 5% 5% 5% 5% 5% 5% 5% 5 5 1 1 3 3 2 1 120 120 5% 540 110 #N/A 5% 5% 1 3 1 1 1 1 3 3 2 2 1 1 190 180 540 #N/A 5% 3% 360 190 5% Event Analysis - - EventID TotalRegistrants 23 Bonus 150.00 66 170.00 . EventType Annual Conference Peer Networking Plant Tour Plant Tour Peer Networking Survey/Study Registration Goals EventID Registration Goal EVNT-0037 20 EVNT-0012 70 EVNT-0042 25 EVNT-0022 40 EVNT-0017 20 EVNT-0032 25 EVNT-0037 EVNT-0012 EVNT-0042 EVNT-0022 EVNT-0017 EVNT-0032 27 Action Goal_Met $ Promote_Event $ Goal_Met $ Promote_Event $ Goal_Met $ Promote_Event $ 180.00 - 38 170.00 21 24 140.00 70.00 0 1 2 3 4. 20 Annual Conference Peer Networking Plant Tour Survey/Study 5 Goal Met 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 $ $ $ $ 6 7 3 9 1 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 2 3 4. 5 6 7 3 ClientRegistration EventDetails EventAnalysis + Event Details EventType Registration Fee EventID EventName 2019 Benchmarking Conference EVNT-0037 Attendee EVNT-0012 January HR Peer Networking EVNT-0042 Toyota Plant Tour EVNT-0022 Marsh Bellofram Plant Tour EVNT-0017 Human Resource Professionals EVNT-0032 State of the Industry Annual Conference $ Peer Networking $ Plant Tour $ Plant Tour $ Peer Networking $ Survey/Study $ 120.00 180.00 250.00 190.00 110.00 180.00 1 2 M11 X fic E F G H I J K L M N 8 9 Event Friends Amount Due Guests Discount 3% 3 1 2 1 1 2 1 Board Membe Registration Fees Discount 360 5% 120 360 120 #N/A 500 #N/A 190 950 250 #N/A 110 570 360 #N/A 10 Company Name 11 SEA-LECT Plastics Corporation 12 SMT LLC 13 Southern Indiana Plastics 14 Southwest Mold Inc. 15 SPI Industries Inc. 16 Steinwall Inc. 17 Stihl Incorporated 18 Tasus Corporation - Alabama 19 Tasus Corporation - Texas 20 Team 1 Plastics 21 Technical Industries Inc. 22 Thogus Products Company 23 Trademark Plastics Inc. 24 Treemen Industries Inc 25 Vantec Inc. 26 Venture Plastics 27 Wabash Plastics Inc. 28 GTM Plastics Inc. 29 GTR Enterprises 30 Hansen Plastics Corporation 31 32 DateRegistered 11-Jan-19 17-Dec-18 16-Feb-18 09-Feb-19 07-Apr-19 30-Mar-18 23-Jul-19 17-Feb-18 05-May-18 22-Aug-18 01-Apr-18 01-Nov-18 14-Jun-19 10-Mar-18 21-Jul-18 28-Nov-19 24-May-18 01-Jul-18 04-Feb-18 22-Jun-18 3% EventID EVNT-0037 EVNT-0037 EVNT-0012 EVNT-0037 EVNT-0042 EVNT-0022 EVNT-0022 EVNT-0042 EVNT-0017 EVNT-0022 EVNT-0012 EVNT-0037 EVNT-0037 EVNT-0032 EVNT-0017 EVNT-0022 EVNT-0032 EVNT-0012 EVNT-0032 EVNT-0022 Discount 5% 5% 5% 5% 5% 5% 5% 5% 5% 5% 5% 5% 5 5 1 1 3 3 2 1 120 120 5% 540 110 #N/A 5% 5% 1 3 1 1 1 1 3 3 2 2 1 1 190 180 540 #N/A 5% 3% 360 190 5% Event Analysis - - EventID TotalRegistrants 23 Bonus 150.00 66 170.00 . EventType Annual Conference Peer Networking Plant Tour Plant Tour Peer Networking Survey/Study Registration Goals EventID Registration Goal EVNT-0037 20 EVNT-0012 70 EVNT-0042 25 EVNT-0022 40 EVNT-0017 20 EVNT-0032 25 EVNT-0037 EVNT-0012 EVNT-0042 EVNT-0022 EVNT-0017 EVNT-0032 27 Action Goal_Met $ Promote_Event $ Goal_Met $ Promote_Event $ Goal_Met $ Promote_Event $ 180.00 - 38 170.00 21 24 140.00 70.00 0 1 2 3 4. 20 Annual Conference Peer Networking Plant Tour Survey/Study 5 Goal Met 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 $ $ $ $ 6 7 3 9 1 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 2 3 4. 5 6 7 3 ClientRegistration EventDetails EventAnalysis +
