How to use excel to be greater than or less than the corresponding formula

How to use the corresponding formula for greater than or less in excel?

For example, in my EXCEL data, if the score is greater than or equal to 95 points, the grade is A; if the score is less than 95 points and greater than or equal to 85 points, the grade is B; if the score is less than 85 points, the grade is It is grade C.

How to set this formula

Enter

=IF(A1>=500,A1-30,IF(A1>=300,A1-20,IF(A1>=200,A1-10,A1)))

or

=A1-IF(A1>=500,30,IF(A1>=300,20,IF(A1>=200,10,0)))

Recommended: "Excel Tutorial 》

The above is the detailed content of How to use excel to be greater than or less than the corresponding formula. For more information, please follow other related articles on the PHP Chinese website!