Current location - Education and Training Encyclopedia - University rankings - How to use if and other logical functions in Excel to make final evaluation?
How to use if and other logical functions in Excel to make final evaluation?
1. The computer opens the Excel table, and inputs the formula =RANK(B2, $B$2:$B$9) to calculate the ranking.

2. Press Enter to get the ranking.

3. Copy the formula from the drop-down box and calculate everyone's ranking.

4. enter the formula =IF(COUNTIF(B2, "& gt=80"), "excellent", if (countif (B2,).

5. Enter and copy. If it is greater than 80 points, it shows excellent; If it is greater than 60 and less than 80, it will be displayed as passed; If it is lower than 60, it is displayed as poor.

Related articles
  • What's the name of the actor who plays Feng in Legend of the Sword and the Chivalrous Man 3? He looks handsome, too ! ! ! !
  • What month is the second semester?
  • City ranking with the most universities
  • How to register for Pocket University APP?
  • How to find the key research institutions of Qingdao University Graduate School
  • They set up a rollover? How did Ke Jie, a stupid Go player, get involved in women's rights?
  • North university of china's double first-class construction
  • What textbooks does the School of Economics and Management of Wuhan University use?
  • Which is better, University of Southern California or Rice University?
  • Where is the dirt in the train bathroom?

    • copyright 2024 Education and Training Encyclopedia All rights reserved