Let’s take a look at how to multiply the numbers in the table by a fixed value:
1. First enter a row of numbers in the table and select after the number. A cell
2. Enter the formula A1*2 (cell where the number is * fixed number) in the selected cell
3. Enter the formula and press Enter to get the result
4. Place the mouse cursor in the lower right corner of the cell where the result is located, and wait until the cursor turns black When using a cross, hold down the left mouse button and pull down to multiply each line by a fixed number.
The above is the detailed content of excel multiply fixed value formula. For more information, please follow other related articles on the PHP Chinese website!