Thanks Dave... This was my problem. Didn't have automatic selected.

"Dave Peterson" wrote:

Make sure you have calculation set to automatic:
tools|options|calculation tab

And I'd use this formula instead:

=if(c2<c3,1,"")

cells that contain spaces look empty, but can screw up other formulas if you're
not careful:

=if(d2="","nothing in there","not empty")

sgausti wrote:

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?

--

Dave Peterson