WPS Office

Free All-in-One Office Suite with PDF Editor

Edit Word, Excel, and PPT for FREE.

Read, edit, and convert PDFs with the powerful PDF toolkit.

Microsoft-like interface, easy to use.

Windows • MacOS • Linux • iOS • Android

# Use IF function to judge data

Uploaded time: August 31, 2021 Difficulty Beginner

# Use IF function to judge data

Use IF function to judge data

The IF function can judge the specified condition and give two results when the condition is established and when it is not.

Here is a staff interview form. Now we need to count the people who passed the interview quickly. If the interview score is greater than or equal to 6, the interviewee is passed, but the interviewee is unqualified if the interview score is less than 6. Here, we can use the IF function to judge the result of the interview quickly.

The IF function syntax is as followed:

IF=(logical_test,value_if_true,value_if_false)

We select cell J3 and click the Formulas tab. Click Insert Function and enter IF.

Now a dialog box will pop up. We need to enter the judgment criterion in the Logical-test.

The criteria for passing the interview are: the interview score needs to be greater than or equal to 6.

So we need to select the data in the Interview Score column. First, select I3, and then continue to enter the criterion: >=6.

Enter Pass in Value_if_true and enter Fail in Value_if_false.

This formula means that if the interview score meets >=6, then a Pass will be prompted.If the interview score does not satisfy >=6, it will prompt Fail.

Finally click OK to get the result.We can double-click the lower right corner of the cell to get all interview results quickly.

To be office excel advancers, we could learn how to use WPS Office Spreadsheet online in WPS Academy.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.