min max and if command issue

[scolty1985]

im currently stuck on the following

=IF((H2/E2)>=$O$2,1,IF(AND((H2/E2)<$O$2,(H2/E2)>=$O$3),0.5,0.25))

the above code is used to change a variable when the output signal stored in column H is less than the maximum recorded value witnessed in column H (Stored in column E).

What im now trying to do is once one of these lower triggers (O$2$, or O$3$) is triggered but the output signal then increases X percent from the lowest value (measured from the trigger of o$2$ or o$3$), i would like to change the variable back to 1.

ie something like this

if variable is now 0.5 or 0.25, begin recording min values

if current value is x% greater than min value, change variable to 1.


Is this possible?

Thanks

 

[shemayisroel]

Not sure exactly what your trying to achieve

Could you post some sample data along with your expected results.

 

[scolty1985]

www.filedump.net/dumped/examplemrexcel1279663406.JPG

Sorry for the late reply. the link above is a screen shot of what i was trying to do. There is a section of text included explaining the specific point where its suppose to increase again.

If you could have a look i would really appreciate it

Rgds

Scolty