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!