如何扩展一半动态公式

如何扩展一半动态公式

本文介绍了如何扩展一半动态公式?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

假设我在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.

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

09-03 00:43