How to use the IF function

The IF formula, as one of the most commonly used functions, can determine whether a condition is TRUE or FALSE, so as to get one of the two values. In this article, you will see the explanation of IF function, several examples of IF formula, as well as a case demonstration. · Explanations of IF formula: IF(logical_test, value_if_true, [value_if_false])· logical_test (necessary): the condition to be compared· value_if_true (necessary): the value to be presented as the result when the “....

How to open PDF measure tool？

Use WPS Office to open the PDF, click Comment → Measure Tool. You can see a new column Measure Tool in the toolbar, and you can select any of them as needed. Here take Distance as an examples. 1. Select Distance. Move the cursor to the starting point and click it. 2. Then move the cursor to the end point and at the same time, you can see a red line and the value of distance changing as your cursor moves. Lastly, double click the end point. 3. The distance appears over the red line. ....

Compare two sheets for duplicate rows in WPS Office Excel

Welcome to WPS Official Academy to check the contents of how to compare two excel spreadsheets for duplicate rows. It would be a waste of time to search for duplicate rows by comparing each two rows manually. WPS Office provides a function of Highlight Duplicates to help you compare two sheets for duplicate rows quickly. Let’s have a try step by step. Here we take two lists of participants as examples. We want to find out the participants who have participated in both conferences by hi....