如何扩展一半动态公式？ [英] How do I extend a half dynamic formula?

问题描述

假设我在A1 B1和C1中有3个数字，我想计算出D1中分割结果的值，我想将其写入A2 B2和C2。我在A2中写下公式：

  A1 / D1 
  

它给了我正确的结果。但是当我将A2转移到B2和C2时，正在复制到B2和C2的表单是：

  B1 / E1 
 C1 / F1 
  

当我想要的是：

  B1 / D1 
 C1 / D1 
  

意思是，formule（分子）的一个变量根据公式（分母）的行和其他变量是const而改变。如何做到这一点？

解决方案

只需将 $ 这样签名。

  = A1 / $ D1 
  

这样，当您将公式拖动到右边时， D1 参考将不会更改

因为它被锁定在前面的 $ 符号。

如果你想锁定 D1 当您向下拖动公式时，在 D1 $ c $ c>这样。

  = A1 / $ D $ 1 
  pre> 
 
 
这将使列$ {code> D1 引用按列逐行锁定。
 
 
 
同样地，如果你只想按行锁定 D1 ，请像这样删除 $  ：
  = A1 / D $ 1 
  
希望这有帮助。
 
Let's say I have 3 numbers in A1 B1 and C1, and I want to calculate the values of their division result in D1, and I want it to be written to A2 B2 and C2. I write in A2 the formula:
A1/D1
And it gives me the right result. But when I extand A2 to B2 and C2, the formule that's being copied to B2 and C2 is:
B1/E1
C1/F1
When what I want is:
B1/D1
C1/D1
Meaning, one variable of the formule (the numerator) is changing according to the row and the other variable of the formula (the denominator) is const. how can I do that?
解决方案
just lock the denominator by putting $ sign like this.
=A1/$D1
This way, when you drag the formula to the right, D1 reference will not change

since it was locked by $ sign placed in front.

If you want to lock D1 when you drag the formula downward, add another $ sign

behind D1 like this.
=A1/$D$1
This will make D1 reference locked by column and by row.

Similarly, if you just want D1 locked by row, remove $ sign in front like this:
=A1/D$1
Hope this helps.

                        
这篇关于如何扩展一半动态公式？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！