Why variable do not move in my formula

[coolasia]

HI

I have create an excel formula that I need to input data daily.

Every day, I need to insert a line and input my new data.

Below is my formula

=IF(V159="Skip","Go",IF(P160>0,IF(COUNTIF(C60:D154,">"&H159+3),"Good"),IF(COUNTIF(C60:D154,"<"&H159-3),"Good")))


The problem is that when I insert a line. Most of my variable will change according except C60:D154

As you can see below

V159 change to V160 = This is good

C60:D154 do not change accordingly. How can I make it change accordingly ?? Why it is not changing when I insert a line ?

=IF(V160="Skip","Go",IF(P161>0,IF(COUNTIF(C60:D154,">"&H160+3),"Good"),IF(COUNTIF(C60:D154,"<"&H160-3),"Good")))


Hope someone can advise me.

Thanks

Ken Chua

[k64]

Did you insert the line above C60? It works for me when I do that.

[coolasia]

I cannot understand. When I create the formula alone without any data. It work

When I use it in my excel file....it fail...strange

[k64]

That is strange. What if you copy your data to a new file?

[coolasia]

I try copy it in the new file but it cant work too.

Is there problem with my data ?

Kindly see attachement.

I have the formular at column Z277

=IF(Y277="Go","No Trade",IF(S278>0,IF(COUNTIF(F176:G268,">"&K277+3),"Good"),IF(COUNTIF(F176:G268,"<"&K277-3),"Good")))

When I insert above Z277 with an empty line. F176:G268 do not change.

Not sure why

Can you help to use my file and see if you can insert and let the variable change at your side ?

[k64]

If just inserted two rows up at row 1 and now it reads

Please Login or Register  to view this content.

[coolasia]

HI Thank. I understand now. I must insert above F178 for it to change the variable.

[k64]

Glad I could help Thanks for the +Rep!