Download WPS Office for your device

The AND function is one of the commonly-used logical functions. When we need to test multiple conditions, it can quickly return the results. It will return TRUE if all of the arguments evaluate TRUE. Otherwise, it will return FALSE as its result. The syntax is stated as follows: AND(logical1,logical2, ...)Logical 1 is the first condition, while logical 2 is the second condition to evaluate, and up to 255 arguments are allowed in AND Function. Take this table as an example. With the sal....

When judging multiple conditions, lengthy IF function will make it difficult for others to understand the logic when editing, here, IFS function can be put to good use.The grammatical structure of IFS function is "= IFS (logical _ test1, value _ if _ true1, [logical _ test2, value _ if _ true2], ...)", making nesting layer by layer unnecessary, thus simplifying the formula. Taking this form as an example, we would like to grade students' scores according to the four conditions of ....

Sometimes we need some preconditions to improve the validity when inputting data. Today we will learn how to set formulas as the validation condition.For example, we only need to enter the spouse's name if the marital status in column D is "married."First, select the cell area E3: E11, click "Validation" in the "Data" tab to enter the "Data Validation" dialog, where we can select "Custom" at the "Allow" drop-down box.Then, enter the formula =D3="married." It means that people can ....

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. This is a promotion application form submitted by employees. The company sets two conditions for it.1. Length of service should be more than 3 years; 2: Personal KPI should be rated as A.The Applicant has the qualification to register when any one of the requirements is met. If you are the HR of the company, how can you quickly select qualified employee....

WPS Writer allows users to add various styles of header and footer, including text, pictures, and date and time. So how can we realize inserting date and time? A footer has been added to this document. So here we take the header as an example to show how to insert date and time. Get into the Header/Footer tab and click Date and Time to pop up the dialog. On the left-hand side of the dialog, we can choose from different formats to present the date and time. Check the Update automaticall....

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 follo....

The Conditional Formatting function can format the cells fulfiling specific conditions. With this function, we can quickly compare data in a worksheet. The worksheet in this example records the performance of staff. What if we want to highlight the Top Three performances? When there is a large amount of data, Conditional Formatting can quickly filter the first three maximums. 1. Select cell C2. 2. Then, press Ctrl + Shift + DOWN (↓) for quick selection from cell C2 to C26 (C2:C26).3. G....

Do you know how to virtualize data with the Conditional Formatting function? The worksheet presents the data of 'Likes to views ratios'. Today's tutorial will take this sheet as an example for data virtualising. Select the cell range B2:B10. Go to Home and click Conditional Formatting. Next, choose Data Bars and then the red Gradient Fill option. After that, we can see the data virtualized with red bars.Although the data in cell B13 is 66.42%, as we can see, the data bar fi....