Way To Copy Formula In Column Without Changing All Cell Numbers
 

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

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

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

Assisance appreciated !
Travelersway


--
travelersway
------------------------------------------------------------------------
travelersway's Profile: http://www.excelforum.com/member.php...o&userid=17623
View this thread: http://www.excelforum.com/showthread...hreadid=401681

So you want C1 and C2 to never change?

You could try:

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



travelersway wrote:

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

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

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

Assisance appreciated !
Travelersway

--
travelersway
------------------------------------------------------------------------
travelersway's Profile: http://www.excelforum.com/member.php...o&userid=17623
View this thread: http://www.excelforum.com/showthread...hreadid=401681

--

Dave Peterson

Thanks Dave, it worked great !

Travelersway


--
travelersway
------------------------------------------------------------------------
travelersway's Profile: http://www.excelforum.com/member.php...o&userid=17623
View this thread: http://www.excelforum.com/showthread...hreadid=401681