ExcelBanter - An IF question

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - An IF question (https://www.excelbanter.com/new-users-excel/122519-if-question.html)

pcor

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

Bernie Deitrick

An IF question

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

All times are GMT +1. The time now is 05:10 AM.