Published On Mar 16, 2022
RELATIVE - When dragging functions, the location of the input cells change relative to the location of the function.
ABSOLUTE - When dragging functions, the reference cell does NOT move as follows...
$A$1: Column and Row do NOT change when copied.
A$1: Row does NOT change when copied.
$A1: Column does NOT change when copied.
*** The $ placed before the letter or number of the cell creates an absolute reference.
show more