Question: please help Click cell B13. Using an HLOOKUP nested in an AND function nested in an IF function, return either Split Class or Can't Split

Click cell B13. Using an HLOOKUP nested in an AND function nested in an IF function, return either Split Class or Can't 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
