Thread: An IF question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
pcor pcor is offline
external usenet poster
 
Posts: 148
Default An IF question

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