1. The instructors for each class are listed on the Data worksheet in range B12:H14. The instructors for the class in cell A4 need to be counted. In cell B12, create a complex function that will determine the number of instructors for the class listed in A4. Use the COUNTA, INDIRECT, INDEX, and MATCH functions. Use the Class_IDs named range inside the MATCH function and the ClassNames named range inside the INDEX function.

2.

Click cell B13. Using an HLOOKUP nested in an AND function nested in an IF function, return either Split Class or Cant Split based on business options. Two conditions are needed to determine if a class can be split. Using the ClassInfo table, one row shows if a class can be split. That condition can be determined with a HLOOKUP. The second is if there is more than one instructor as shown in cell B12. If both conditions are met, the class can be split. Otherwise, the class cannot be split.

Please solve all of the steps for a Mac. Thank you.

Home Insert Draw Page Layout Formulas Data Review View Automate Tell me Open recovered workbooks? Your fecent changes were saved. Do you want to continue working where you left oft? Home Insert Draw Page Layout Formulas Data Review View Automate Q Tellme A1 A . A . Do you want to continue working where you left oft