pcor,

=IF(B3<OFFSET(B3,1,0),"NOWAY","")

HTH,
Bernie
MS Excel MVP


"pcor" wrote in message
...
I have a formula in col G that goes like this
=if(b3<b4),"NOWAY","")
that fomula has been copies from G4 to g100
and it works fine BUT
if I insert a line anywhere between G 4 and g100 the formula no longer
functions and I haveto recopy the formula.
How can enter this formula so that it is "self adjusting"
Thanks