# Thread: Insert cell fouls formula (2003 (11.56.12.5606))

1. ## Insert cell fouls formula (2003 (11.56.12.5606))

I know this is probably under "so easy a toddler could do it", but it's been a long week. I'm trying to help a colleague who gets data to fix, and the easiest way to do it is import into Excel and move it around. She has data in column A & B, then created a formula in column C to help her find the clunkers, for example, =IF(A5=B5, "OK", "NO"). She sees a NO in C5, and she can fix it by inserting a blank cell at B5, moving it to C6. But, the formula in C6 changes to =IF(A6=B7, "OK", "NO"). I've tried using absolute and mixed cell references, and the INDIRECT and OFFSET functions, but I'm just spinning my wheels. Any help would be appreciated!

2. ## Re: Insert cell fouls formula (2003 (11.56.12.5606))

You could use this formula in C2:

=IF(OFFSET(C2,0,-2)=OFFSET(C2,0,-1), "OK", "NO")

and fill down as far as needed.

3. ## Re: Insert cell fouls formula (2003 (11.56.12.5606

It works great. I knew I was close, but just hadn't put the pieces together. Thanks a million, and have a great weekend!

4. ## Re: Insert cell fouls formula (2003 (11.56.12.5606

Jim, just a little point so your chum has less typing:
if she replaces
=IF(A5=B5, "OK", "NO")
with this
=A5=B5 and copies down, then she'll get the answers TRUE or FALSE
This might save a few milliseconds in her busy day!

5. ## Re: Insert cell fouls formula (2003 (11.56.12.5606

Thanks very much, John!

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•