=90) in the cell ,"Excellent",""))"; finally drop down the formula."/> =90) in the cell ,"Excellent",""))"; finally drop down the formula.">
search

Home >Topics >excel >How to set up excel to display passing value when it is greater than 60

How to set up excel to display passing value when it is greater than 60

藏色散人
藏色散人Original
2020-02-20 09:29:3212871browse

How to set up excel to display passing value when it is greater than 60

How to set up excel to display passing grade when it is greater than 60?

Assume that the data is in column B and column C displays the grade. The formula is as follows:

C2=IF(B2<60,"Failed",IF(B2>=90,"Excellent",""))

Microsoft Excel is one of the components of Microsoft Office software, Microsoft Office , is a spreadsheet software written and run by Microsoft for computers with Windows and Apple Macintosh operating systems. Excel is an important part of the Microsoft Office suite of software. It can perform various data processing, statistical analysis and auxiliary decision-making operations. It is widely used in many fields such as management, statistics and finance, and finance.

Recommended: "excel tutorial"

The above is the detailed content of How to set up excel to display passing value when it is greater than 60. For more information, please follow other related articles on the PHP Chinese website!

if windows microsoft excel
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 set uneven coordinate axis scale in ExcelNext article：How to set uneven coordinate axis scale in Excel

Related articles

See more