Way To Copy Formula In Column Without Changing All Cell Numbers

T

travelersway

Is there a way to copy a formula in a column without changing all th
cell numbers?

Example: =IF(C1=C2, A1,0)

How would I copy that down a colmn and only change the A1 to A2, A3, A
and so on down the column?

Assisance appreciated !
Travelerswa
 
D

Dave Peterson

So you want C1 and C2 to never change?

You could try:

=IF($C$1=$C$2,A1,0)
 
Top