In cell C17, create a nested formula using the INDEX and MATCH functions that returns the Number of participants for the Bedroom workshop type. 1 2 3 Workshop Cost Per Person 4 5 6 7 8 Workshop ID 01-KT 02-BT 03-BD 04-LD 05-LR 06-GR 07-CL 08-WL Type Kitchen Bathroom Bedroom Laundry Room Living Room/Great Room Game Room Closet Intervention Wall Décor Lighting Cost for each participant $ 25 $ 20 $ 20 $ 10 $ 25 $ 15 $ 10 $ 15 Number of participants Total cost 41 $ 1,025 33 $ 660 19 $ 380 15 $ 150 25 $ 625 13 $ 195 28 $ 280 14 $ 210 TOTAL COSTS $ 3,315 9 10 11 12 13 14 Cost includes facility rental, food, beverages, workbook, promotional materials, staff 15 time, samples, etc. 16 17 No. Participants: 18



Answer :

Other Questions