Constant in Excel Formula
Four choices
$A$1 : both column and row do not change while copying
$A1 : row changes while copying down, no change while copying across
A$1 : column changes while copying across, no change while copying down
A1 : both change while copying across or down
"Chele" wrote:
I remember using the $ i think to keep a column constant when doing a
formula. What is it?
|