How to multiply a column by a fixed value in excel?
- coldplay.xixiOriginal
- 2020-06-23 16:01:3429614browse
How to multiply a fixed value by a column in excel?
How to multiply a column by a fixed value in excel:
1. As shown below, if you want to set all the values in column A to be multiplied by 1.13, then you can Enter 1.13 in a blank cell, then copy the cell, select column A, and click "Paste Options".
2. Click "Paste Special" in the pop-up drop-down menu.
3. Check "Value" in the paste box, check "Multiply" in the operation box, and click "OK".
4. At this time, you can multiply all the values in column A by 1.13, and finally delete the 1.13 cell.
Recommended tutorial: "excel basic tutorial"
The above is the detailed content of How to multiply a column by a fixed value in excel?. For more information, please follow other related articles on the PHP Chinese website!