CLEAR TRIGGER

[brumbie]

Hi guys,
I've spent most of the day working on a formula which lays in running and then backs at a certain price.I felt sure after browsing the forum all day that after getting my first layed what i had to do is leave an "if" in the cell with a "then" with a final code CLEAR-BACK.Am i missing something as although i saw go to CLEAR-BACK in the cell nothing happened?

[GaryRussell]

There is no CLEAR-BACK trigger. You need to use CLEAR and then BACK.

Your formula needs to insert CLEAR and then you will need additional criteria to check that column T is blank before inserting BACK.

[brumbie]

so i've got to put a flag in somewhere

[brumbie]

Ok i'm there now,i've found a place in the formula to place the CLEAR trigger..and then a BACK .....tricky one that...