\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline \multirow{2}{*}{\multicolumn{13}{|c|}{ Client Registrations }} \\ \hline & & & & & & & & & & & & \\ \hline \multirow{2}{*}{\multicolumn{13}{|c|}{BoardMemberDiscountsDiscountEventrtype}} \\ \hline & & & & & & & & & & & & \\ \hline 5% & & & & & & & & & & & & \\ \hline 5%7%10% & PeerNetworkingPlantTour & & & & & & & & & & & \\ \hline & & & & & & & & & & & & \\ \hline Contactio & Eirstrome & lastrome & Boardmember & Company Name & Dateperistered & Eventip & Giverts & RegistrationFeas & BoardmemberDismot & EventDissount & FriendsDiesont & Amount \\ \hlinecN00011 & CharityChamine & & Yes100 & SEA-LECT Plastics Corporaration & & EventivEVNT-0037 & Guests & 360.00es & \begin{tabular}{|c|} Discount \\ 0.05 \\ \end{tabular} & & & \\ \hline & Justin & Wallace & & & & EVNT-0037 & & 3600120.00 & & 5 & & \\ \hline CN0004CN0005 & SlaneeBlake & WassingionBryan & Yes & & & EVNI-DO12EVNT-0037 & & 120.00360.00 & 0.05 & 55 & & \\ \hline CN-0006 & Christine & Tyson & Yes & SPI Industries Inc. & 07 - 07 -Ap-19 & & & 120.00500.00 & 0.07 & 5 & & \\ \hline CN0007 & Cassidy & Lowe & & Steinwall Inc. & 301830Mar-18 & EVNT-0022 & & 10000190.00 & & 55 & & \\ \hline CN-0008 & Sloane & Shaffer & Yes & tith Incorporated & 17fech1823Jul19 & EVNT-0022 & & 2500950.00313 & & 55 & 3 & \\ \hline & & & & & & & & 111.0025.00 & & & & \\ \hline & Adena & Hency & & Team 1 Plastics & & EVNT-0022 & & 570.00170.00 & & 5 & & \\ \hline CNN-00013 & Barrett & Gonzales & YesYos & Technical Industries Inc & 01-Apr-18 & EVNT-0012 & & 360.00 & 0.05 & 5 & & \\ \hline cN-00014 & Angelica & Marquez & & Thogus Products Company & 01-Nov-18 & & & 120.00 & & 5 & & \\ \hline & Christine & Hughes & & & 10219144un-19 & & & & & & & \\ \hline CN.00020 & Heidi & Estes & Yes & Vantecinc. & 21Jul18 & EVNTT-0017 & & 110.00 & 0.05 & 5 & & \\ \hline & Rebecca & Greene & & & 28-Nov-19 & & & 1800190.00 & & & & \\ \hline CN-00025 & & HensonOneil & Yes & & & & & 540.00 & 0.05 & 5 & & \\ \hlineCN0027CN0026 & Jeremy & Sullivan & & & & & & & & & & \\ \hline & Dora & & & & & & & & & & & \\ \hline & & & & & & & & & & & & \\ \hline & & & & & & & & & & & & \\ \hline \end{tabular} 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. Hint: Because there may be blanks among the discounts, you cannot use a simple formula to add the discounts. Instead, use a sum function, which ignores blanks instead of giving an error