That depends what you actually want to compare.
If, in the line below the original you want C3<C4 then it should work, but
if eg you always want to compare to C2 (eg C2<C4) then you need to tell
Excel it's an absolute reference ie enter C2 as $C$2 (or if you only want to
lock the row number C$2).

--
Ian
--
"sgausti" wrote in message
...
I have a simple formula =IF(C2<C3,1," "). This formula works perfectly
when
I type it in. I have a spreadsheet with over 10000 lines and want to copy
this formula down. When I copy the formula and paste it, it no longer
gives
me the correct output. What can I do?