Can't autofill an 'if' function with text in the logical_test

[KathyG]

My logical test is =IF("D2"="E2",1,2). When I autofill or copy down, the row numbers do not change to "D3"="E3", etc. How do I delineate text and also have the ability for autofill or copy to change the rows as it goes?

[Jonmo1]

Not sure I understand.

"D2"="E2" will never be true, even as it fills down to "D3"="E3" and "D4"="E4"

[ConneXionLost]

Have you tried:

Please Login or Register  to view this content.

Cheers,