=500,A1-30,IF(A1>=300,A1-20,IF(A1> =200,A1-10,A1)))”."/> =500,A1-30,IF(A1>=300,A1-20,IF(A1> =200,A1-10,A1)))”.">
简体中文（ZH-CN） English（EN） 繁体中文（ZH-TW） 日本語（JA） 한국어（KO） Melayu（MS） Français（FR） Deutsch（DE）
Home
Article
Q&A
Course
Topic
Download
Game
Dictionary
Recent Updates

Home>Article>Topics> How to use excel to be greater than or less than the corresponding formula

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

藏色散人
藏色散人 Original
2020-05-21 09:08:11 30805browse

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!

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 problems Next article：How to use Excel to solve problems

Related articles

See more