Current location - Training Enrollment Network - Mathematics courses - How to calculate multiplication in wps table? For example, all the numbers in a column are multiplied by 2.
How to calculate multiplication in wps table? For example, all the numbers in a column are multiplied by 2.
The method is as follows:

1. Open the form and enter the required data.

2. Take the form as an example. B=A 1*2。 Enter "=" in the first cell under "B".

3. Click to select A 1 data, then enter *, and then click to select B 1 data.

Then enter the car and the result will come out.

5, there are so many numbers below, just follow the above algorithm one by one, but it's too much trouble. You can put the mouse in the cell with the result of "30". Move the mouse until the mouse in the lower right corner becomes+,and then pull down the mouse, and the desired result will appear.

Extended data

Query and reference function

When you need to find a specific value in a data list or table, or you need to find a reference to a cell, you can use the query and reference worksheet function. For example, if you need to find a value in a table that matches the value in the first column, you can use the VLOOKUP worksheet function. If you need to locate values in a data list, you can use the MATCH worksheet function.

Mathematics and trigonometric functions

With math and trigonometric functions, you can handle simple calculations, such as rounding numbers, summing values in a cell range, or complex calculations.

Statistical function

The statistical worksheet function is used for statistical analysis of the data area. For example, the statistical worksheet function can provide information about a straight line drawn by a set of given values, such as the slope and Y-axis intercept of the straight line, or the actual point values that make up the straight line.

Text function

Text functions allow you to manipulate text strings in formulas. For example, you can change the case or determine the length of a text string. You can insert or connect a date to a text string. The following formula is an example of how to use the function TODAY and the function TEXT to create a message containing the current date and representing the date in the format of "dd-mm-yy".

=TEXT(TODAY()," dd-mm-yy ")

References:

Application of WPS function in Baidu Encyclopedia