Current location - Education and Training Encyclopedia - Graduation thesis - On the Application of excel if Function
On the Application of excel if Function
Suppose g is listed as the participation rate, and the proportion of participants in the total number of college students.

The data starts from the third line where the School of Communication is located.

In H3, enter:

=IF(G3=MAX($G$3:$G$ 16), "excellent college", "non-excellent college")

Drop down formula.