Use the Today function to quickly calculate days between dates

In the application of WPS Office Spreadsheet, we usually calculate days between dates. So, how can we do a quick calculation? First, I will teach you how to use Today function to calculate days between the current date and the future date. If you are the HR of a company, you can use the Today function to calculate the remaining time of each employee's contract period when you manage the contract period of your employees. It can clearly show you the employees whose contracts are abo....

Use the DATEDIF function to calculate the intervals of dates

The DATEDIF function is mainly used to calculate days, months, or years between two dates. Now we are going to use this table to show you the usage of this function. This table records the entry date of the company’s employees. Now we want to calculate the employee’s year of service. We can first click cell C2 and then click Insert Function. Insert DATEDIF in the Search for Function of the dialog box. Click the OK button, and then the Function Arguments dialog box will pop up.Start dat....

Look up data quickly with LOOKUP function

Today I would like to introduce you to the LOOKUP function, which has many relevant knowledge points. Beginners will have some difficulty in learning the LOOKUP function, and the video will introduce the common use of this function and the notes in the process of using it. Take this spreadsheet as an example. If we want to find out who is the purchaser based on the lump sum in cell J9, we can use the LOOKUP function. The general statement structure of the LOOKUP function is LOOKUP (Loo....

SUBTOTAL function: Calculate the data with the hidden value

Take this table as an example. When using the SUM function to do summations, we may find two rows hidden in the table, but the result of the summation still includes the hidden value. So how can we calculate the data containing hidden values and get a result that does not include the hidden values? This video can help us and it can be also used in Microsoft Office Excel and Openoffice. In this case, we can use the SUBTOTAL function. Next, we are going to show you the usage of the SUBTO....

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

Use SUMIFS function with multiple criteria

In our work, we often need to filter through multiple criteria for statistics. At this time, we can use the SUMIFS function. The grammatical structure of the SUMIFS function is: “SUMIFS（Sum range, Range1, Criteria 1, Range2, Criteria2...）”Using the data in this table as an example, we want to calculate The total amount of imported fruits from South Korea greater than $50,000. There are two conditions. One is South Korea, and the other is the amount>$50,000.First, after clicking cell E5....

How to use the Excel MID function

When using WPS Spreadsheets to process data, sometimes we need to catch part of the data from a series of numbers. We can use the MID formula to realize it, to catch up a certain length of characters from a series of numbers. In this example, there is a list of phone numbers. The MID function can extract the long series of numbers, keeping the last seven numbers when removing the first three characters. Select cell D2 and click the Insert Function to pop up the Search for a function d....

Use COUNT function to count the number of cells with parameters

When we do data statistics, we can use the COUNT function to count the number of cells containing values. Take this table as an example. We need to count the number of cities participating in donations. Click cell E6 and click Insert Function to find the COUNT function. Click the OK button, now a dialog box will pop up.Value 1 and Value 2 refer to the cell range to be statistically calculated. Only the numeric parameters are counted in this part of the range, that is to say, the number....