问题描述
假设我在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
behindD1
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.
这篇关于如何扩展一半动态公式?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!