WPS Mobile Version Practical Tutorial: Using the IF function as a score rating

Source: Internet
Author: User

Work, study, a lot of exams, often encounter rating problems. Especially in recent years, people are increasingly aware of the problem of examination results are private. The grading of the test scores into grades is a form of implementation by many schools. Actually very simple, WPS mobile version of the table function can easily complete this matter. This article describes how to use the IF function to divide the score into a,b,c,d four grades.

First of all, in the WPS Mobile version of the nested if function to achieve the score grade conversion, you must set the conditions to use the IF function. Suppose that A, B, C, d four grades correspond to four fractional segments, that is, 60 points (including) below the D level, 60~70 (including) is C-class, 70~90 is divided into B, 90 points (inclusive) above is a class. Total is divided into 100 points.

Open the form file you want to convert in the WPS mobile version. Here only 15 students of the results as a demonstration, in the actual work, you can according to the requirements of the WPS Mobile version of their own expansion of use.

Double click on the C3 cell, click "T" in the upper left corner of the virtual keyboard, and click on the "F (X)" button on the built-in input method keyboard of the WPS mobile version to select the "IF" function in the list of commonly used functions.

Back to WPS Mobile Moderator interface, the formula bar displays "=if ()" and then, according to the rank corresponding to the score, enters the complete conditional judgment formula in parentheses, namely "=if (b3<=60," D ", if (b3<=70," C ", if (b3<90," B "), "A")) ", confirm and press ENTER, you can see Guo Yan 89 points belong to B class.

After the C3 cell level is obtained, the full level is obtained using the Fill function. The method is to find the Fill function in the menu bar, select the "Drag Fill" way, simple and convenient.

Overall comments: This example explains the use of the IF function again. And by "pairing" the scores and grades of the students, we also analyze how the IF function is nested in the WPS mobile version. With these experiences, students in similar situations will be able to do more with less.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.