Switch between relative, absolute, and mixed references
1.. Select the cell that contains the formula.
2.. In the formula bar , select the reference you want to change.
3.. Press F4 to toggle through the combinations. The "Changes To" column
reflects how a reference type updates if a formula containing the reference
is copied two cells down and two cells to the right.


Formula being copied

Reference (Description) Changes to
$A$1 (absolute column and absolute row) $A$1
A$1 (relative column and absolute row) C$1
$A1 (absolute column and relative row) $A3
A1 (relative column and relative row) C3


--
Don Guillett
SalesAid Software

"Mr. Low" wrote in message
...
Dear Sir ,

I have the formula at =IF(B2=C2,"Yes","No") at A2 and copy downwards to
A20.

I would like the formula to be able to compare each cell at column B and C
even if I move either colu7mn up and down.

Currently I need to copy the formula all over again if any cell in which
the
formula refers to is moved.

A B C
1 Ref A Ref B
2 Yes xxxx xxxx
3 Yes xxxx xxxx
4 No xxxx xxxx
.
.
20 Yes xxxx xxxx


Thanks

Low


--
A36B58K641