IF function of Excel table in OFFICE

Score each student's total score: above 450 points is excellent, below 450 points but above 400 points is good, above 400 points is qualified, and below 300 points is unqualified.

This problem can be solved by the following formula:

= IF(450 & lt； =B2, "excellent", if (400

As shown in the figure.