WPS table function is a pre-defined special formula, which performs data processing tasks such as calculation and analysis. You can get twice the result with half the effort in the process of complex data operation. Let's look at how to use functions to calculate data.
First, run the WPS mobile program. The green sign is a tabular document. Open a document at will.
Double-click your finger in a blank cell of the table, and a gray indicator bar will appear above the custom keyboard. Click "T" on the left to open the dedicated input method for forms that comes with WPS mobile version. Click f(x) to open the function list interface. As shown in the figure below.
In the function list, you can see various functions and formulas. Amo, who is not sensitive to data, said, look at these gobbledygook formulas. It's really dazzling. People who often deal with data, come and find your favorite.
Amo found the most commonly used summation formula as an example and gave you a brief explanation. But different functions are used in different ways, and studious students need to study them themselves.
The summation function is a summation function. It is one of the most commonly used functions in excel. Take the commonly used summation function SUM as an example, and its syntax is "SUM (value 1, value 2, ...)". The following table is an example of SUM function, where A is the column number and 1-5 on the left is the row number.
If you enter the result of the following formula in cell A6:
Example 1 = sum (1, 2,3) gives 6, and calculates the sum of 1, 2,3;
Example 2, = sum (a 1: a2) results in 4, and the sum of cells a 1 to a2 is calculated;
Example 3, =SUM(( 1+2=3), (1+2), (A 1: a2) the result is 8, because the result of the expression (1+2=3) is true, and the result in the computer is 65433.
Example 4: = sum (a 1: a5) results in 4, excluding the literal expression (1+2) and logical expression (1+2=3) in the reference cell.