Question

In cell Q2, insert a function that displays a YES if the total number of morning classes for January is at least 175 and a NO if not.

Answer 1

To display a YES if the total number of morning classes for January is at least 175 and a NO if not, use the IF function in Excel.

Step-by-step explanation:

To display a YES if the total number of morning classes for January is at least 175 and a NO if not, you can use the IF function in Excel.

In cell Q2, you can use the following formula:

=IF(SUM(B2:M2)>=175, "YES", "NO")

This formula will add up the values in cells B2 to M2 and check if the total is greater than or equal to 175. If it is, it will display "YES", otherwise it will display "NO".