overwrites:IF statement help

**Chad Kruse** · 03-04-2011, 10:41 AM

I'm trying to do the following. If cell e54 equals e55 Then copy K53. Otherwise do nothing. I've been trying to use this =IF(E54=E53,K53,K54). It works on the initial cell but when I copy the formula down it overwrites all cells with that first output. Any help is appreciated.

**brokenbiscuits** · 03-04-2011, 10:51 AM

I don't see why that formula wouldn't work dragged down. Do you maybe have manual calculation turned on? Try pressing F9 and see if it updates.

Also, what cell are you putting that formula into?

**Chad Kruse** · 03-04-2011, 10:57 AM

The screen blinks when I hit F9, I'm not sure if that represents having that on or not.

I'm trying to input it into cell K54.

**brokenbiscuits** · 03-04-2011, 11:01 AM

Ah ok, well that explains it, you;re trying to get the cell to refer to itself which is impossible.

If you have a previous formula in column K, simply use =IF(E54=E53,K53,whatever formula was in K54)

If column K is static data, you'd be best off using a helper column (say col L) with the original formula inserted.