How to express fixed multiplication of a certain cell in excel formula

王林
Release: 2024-08-29 13:45:02
Original
910 people have browsed it

How to express the fixed multiplication of a certain cell by the excel formula? Many users need to use this when using Excel, but when faced with this situation, most friends don't know how to set it up so that it can be expressed. So in this issue, the editor will share detailed information with many users. The operation method, I hope it can be helpful to everyone. The operation method is as follows 1. First, double-click to open a spreadsheet on the desktop to demonstrate how to fix the multiplier in multiplication.

excel公式固定乘以某一个单元格怎么表示

2. Enter =B3B2 in cell C3. This will not fix B2. If you want to fix B2 unchanged here.

excel公式固定乘以某一个单元格怎么表示

3. After entering the formula, press the Enter key and the multiplication result will be calculated. If you want to fix the multiplier B2, please proceed below.

excel公式固定乘以某一个单元格怎么表示

4. Enter =B4 in cell C4
and then click the Insert menu, insert a $ in the symbol, enter the formula =B4*$B$2, and then click Back Car key.

excel公式固定乘以某一个单元格怎么表示

5. After pressing the Enter key, you can see that the calculation result is obtained in the cell where the formula was entered.

excel公式固定乘以某一个单元格怎么表示

6. If you want to calculate the following results and fix the result of the multiplier B2, just put the mouse in the lower right corner of the cell to turn it into a cross shape, and then hold down the mouse hand to Drag down to the last cell. The result of the corresponding cell can be obtained.

excel公式固定乘以某一个单元格怎么表示

The above is the detailed content of How to express fixed multiplication of a certain cell in excel formula. For more information, please follow other related articles on the PHP Chinese website!

source:xpwin7.com
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!