Lets say I have one cell A1, which I want to keep constant in a calculation.
(假设我有一个单元格A1,我想在计算中保持不变。)
For example, I want to calculate a value like this: (例如,我想计算这样的值:)
=(B1+4)/(A1)
How do I make it so that if I drag that cell to make a calculation across cells in many rows, only the B1 value changes, while A1 always references that cell, instead of going to A2, A3, etc.?
(如何将其设置为如果我拖动该单元格以在多行中的单元格之间进行计算,则只有B1值会更改,而A1始终引用该单元格,而不是转到A2,A3等?)
ask by dude translate from so 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…