Home  >  Article  >  Topics  >  excel multiply fixed value formula

excel multiply fixed value formula

尚
Original
2019-10-22 14:59:0835748browse

excel multiply fixed value formula

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

excel multiply fixed value formula

2. Enter the formula A1*2 (cell where the number is * fixed number) in the selected cell

excel multiply fixed value formula

3. Enter the formula and press Enter to get the result

excel multiply fixed value formula

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.

excel multiply fixed value formula

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn