How to use excel to be greater than or less than the corresponding formula
- 藏色散人Original
- 2020-05-21 09:08:1130928browse
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!
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：How to use Excel to solve problemsNext article：How to use Excel to solve problems