Need help with creating the above formula

Try:

V>=XAVGV20

Thanks

thank you and sorry to bother.  may have a few more as I am quite rusty

and if I want Price greater than or equal to the 20D EMA of price, is it P>=XAVGP20?

Try c >= XAVGC20

How can I write a condition formula whereby if I have 3 trend definitions (let's say Trend Down, Trend Neutral and Trend Up) I want to scan for securities in Trend Neutral whose last non-Trend Neutral score was Trend Down?  I have my own definition of Trend already, but don't know how to write the formula to condition based on the last non-neutral Trend score.  Thanks in advance for any insights

Without knowing the exact details of your Trend Down, Trend Neutral and Trend Up requirements I could not say for sure, but I suspect you could use the techniques in the Days Since Last Peak (or other day-counting needs) topic for this.

You would need to check for Trend Neutral being true and the count for the number of bars since Trend Up was true to be greater than the number of bars since Trend Down was true.

Bruce L,

Many thanks for the response.  

Here is the trend definition.

Non-Uptrend

xavgc13 < xavgc13.1 OR (XAVGC12-XAVGC26)-(XAVG(XAVGC9,12)-XAVG(XAVGC26,9)) < (XAVGC12.1-XAVGC26.1)-(XAVG(XAVGC9,12.1)-XAVG(XAVGC26,9.1))

Non-Downtrend

xavgc13 > xavgc13.1 OR (XAVGC12-XAVGC26)-(XAVG(XAVGC9,12)-XAVG(XAVGC26,9)) > (XAVGC12.1-XAVGC26.1)-(XAVG(XAVGC9,12.1)-XAVG(XAVGC26,9.1))

Downtrend:

xavgc13 < xavgc13.1 AND (XAVGC12-XAVGC26)-(XAVG(XAVGC9,12)-XAVG(XAVGC26,9)) < (XAVGC12.1-XAVGC26.1)-(XAVG(XAVGC9,12.1)-XAVG(XAVGC26,9.1))

Uptrend

xavgc13 > xavgc13.1 AND (XAVGC12-XAVGC26)-(XAVG(XAVGC9,12)-XAVG(XAVGC26,9)) > (XAVGC12.1-XAVGC26.1)-(XAVG(XAVGC9,12.1)-XAVG(XAVGC26,9.1))

So, I'd want to know that if the following is true:

xavgc13 < xavgc13.1 OR (XAVGC12-XAVGC26)-(XAVG(XAVGC9,12)-XAVG(XAVGC26,9)) < (XAVGC12.1-XAVGC26.1)-(XAVG(XAVGC9,12.1)-XAVG(XAVGC26,9.1))

Then, 

a)  xavgc13 < xavgc13.1 AND (XAVGC12-XAVGC26)-(XAVG(XAVGC9,12)-XAVG(XAVGC26,9)) < (XAVGC12.1-XAVGC26.1)-(XAVG(XAVGC9,12.1)-XAVG(XAVGC26,9.1)) was true more recently then

b) xavgc13 > xavgc13.1 AND (XAVGC12-XAVGC26)-(XAVG(XAVGC9,12)-XAVG(XAVGC26,9)) > (XAVGC12.1-XAVGC26.1)-(XAVG(XAVGC9,12.1)-XAVG(XAVGC26,9.1))

and vice versa

Can you help here?

So I'm not quite sure on the vice versa part. You are checking Non-Uptrend true and Downtrend more recent than Uptrend.

Is the vice versa part then Non-Uptrend is true and Uptrend more recent than Downtrend?

Is the vice versa part then Non-Downtrend is true and Uptrend more recent than Downtrend?

Or would you really just rather have Non-Uptrend or Non-Downtrend true and Downtrend more recent than Uptrend with vice versa part being Non-Uptrend or Non-Downtrend true and Uptrend more recent than Downtrend?

By vice versa, I meant - 

 Non-Downtrend is true and Uptrend more recent than Downtrend?

So the second of your three guesses is what I meant by vice versa

Both of the following should check back 25 bars to find the most recent Downtrend or Uptrend. They can't return true if the most recent Downtrend or Uptrend happened more than 25 bars ago.

For Non-Uptrend is true and Downtrend more recent than Uptrend.

(C < XAVGC13.1 OR 119 * C + 765 * XAVGC12.1 < 65 * XAVGC26.1 + 819 * XAVGC9.1) AND ABS(SGN(119 * C1 + 765 * XAVGC12.2 - 65 * XAVGC26.2 - 819 * XAVGC9.2) = SGN(C1 - XAVGC13.2)) * SGN(C1 - XAVGC13.2) + ABS(SGN(119 * C1 + 765 * XAVGC12.2 - 65 * XAVGC26.2 - 819 * XAVGC9.2) <> SGN(C1 - XAVGC13.2)) * (ABS(SGN(119 * C2 + 765 * XAVGC12.3 - 65 * XAVGC26.3 - 819 * XAVGC9.3) = SGN(C2 - XAVGC13.3)) * SGN(C2 - XAVGC13.3) + ABS(SGN(119 * C2 + 765 * XAVGC12.3 - 65 * XAVGC26.3 - 819 * XAVGC9.3) <> SGN(C2 - XAVGC13.3)) * (ABS(SGN(119 * C3 + 765 * XAVGC12.4 - 65 * XAVGC26.4 - 819 * XAVGC9.4) = SGN(C3 - XAVGC13.4)) * SGN(C3 - XAVGC13.4) + ABS(SGN(119 * C3 + 765 * XAVGC12.4 - 65 * XAVGC26.4 - 819 * XAVGC9.4) <> SGN(C3 - XAVGC13.4)) * (ABS(SGN(119 * C4 + 765 * XAVGC12.5 - 65 * XAVGC26.5 - 819 * XAVGC9.5) = SGN(C4 - XAVGC13.5)) * SGN(C4 - XAVGC13.5) + ABS(SGN(119 * C4 + 765 * XAVGC12.5 - 65 * XAVGC26.5 - 819 * XAVGC9.5) <> SGN(C4 - XAVGC13.5)) * (ABS(SGN(119 * C5 + 765 * XAVGC12.6 - 65 * XAVGC26.6 - 819 * XAVGC9.6) = SGN(C5 - XAVGC13.6)) * SGN(C5 - XAVGC13.6) + ABS(SGN(119 * C5 + 765 * XAVGC12.6 - 65 * XAVGC26.6 - 819 * XAVGC9.6) <> SGN(C5 - XAVGC13.6)) * (ABS(SGN(119 * C6 + 765 * XAVGC12.7 - 65 * XAVGC26.7 - 819 * XAVGC9.7) = SGN(C6 - XAVGC13.7)) * SGN(C6 - XAVGC13.7) + ABS(SGN(119 * C6 + 765 * XAVGC12.7 - 65 * XAVGC26.7 - 819 * XAVGC9.7) <> SGN(C6 - XAVGC13.7)) * (ABS(SGN(119 * C7 + 765 * XAVGC12.8 - 65 * XAVGC26.8 - 819 * XAVGC9.8) = SGN(C7 - XAVGC13.8)) * SGN(C7 - XAVGC13.8) + ABS(SGN(119 * C7 + 765 * XAVGC12.8 - 65 * XAVGC26.8 - 819 * XAVGC9.8) <> SGN(C7 - XAVGC13.8)) * (ABS(SGN(119 * C8 + 765 * XAVGC12.9 - 65 * XAVGC26.9 - 819 * XAVGC9.9) = SGN(C8 - XAVGC13.9)) * SGN(C8 - XAVGC13.9) + ABS(SGN(119 * C8 + 765 * XAVGC12.9 - 65 * XAVGC26.9 - 819 * XAVGC9.9) <> SGN(C8 - XAVGC13.9)) * (ABS(SGN(119 * C9 + 765 * XAVGC12.10 - 65 * XAVGC26.10 - 819 * XAVGC9.10) = SGN(C9 - XAVGC13.10)) * SGN(C9 - XAVGC13.10) + ABS(SGN(119 * C9 + 765 * XAVGC12.10 - 65 * XAVGC26.10 - 819 * XAVGC9.10) <> SGN(C9 - XAVGC13.10)) * (ABS(SGN(119 * C10 + 765 * XAVGC12.11 - 65 * XAVGC26.11 - 819 * XAVGC9.11) = SGN(C10 - XAVGC13.11)) * SGN(C10 - XAVGC13.11) + ABS(SGN(119 * C10 + 765 * XAVGC12.11 - 65 * XAVGC26.11 - 819 * XAVGC9.11) <> SGN(C10 - XAVGC13.11)) * (ABS(SGN(119 * C11 + 765 * XAVGC12.12 - 65 * XAVGC26.12 - 819 * XAVGC9.12) = SGN(C11 - XAVGC13.12)) * SGN(C11 - XAVGC13.12) + ABS(SGN(119 * C11 + 765 * XAVGC12.12 - 65 * XAVGC26.12 - 819 * XAVGC9.12) <> SGN(C11 - XAVGC13.12)) * (ABS(SGN(119 * C12 + 765 * XAVGC12.13 - 65 * XAVGC26.13 - 819 * XAVGC9.13) = SGN(C12 - XAVGC13.13)) * SGN(C12 - XAVGC13.13) + ABS(SGN(119 * C12 + 765 * XAVGC12.13 - 65 * XAVGC26.13 - 819 * XAVGC9.13) <> SGN(C12 - XAVGC13.13)) * (ABS(SGN(119 * C13 + 765 * XAVGC12.14 - 65 * XAVGC26.14 - 819 * XAVGC9.14) = SGN(C13 - XAVGC13.14)) * SGN(C13 - XAVGC13.14) + ABS(SGN(119 * C13 + 765 * XAVGC12.14 - 65 * XAVGC26.14 - 819 * XAVGC9.14) <> SGN(C13 - XAVGC13.14)) * (ABS(SGN(119 * C14 + 765 * XAVGC12.15 - 65 * XAVGC26.15 - 819 * XAVGC9.15) = SGN(C14 - XAVGC13.15)) * SGN(C14 - XAVGC13.15) + ABS(SGN(119 * C14 + 765 * XAVGC12.15 - 65 * XAVGC26.15 - 819 * XAVGC9.15) <> SGN(C14 - XAVGC13.15)) * (ABS(SGN(119 * C15 + 765 * XAVGC12.16 - 65 * XAVGC26.16 - 819 * XAVGC9.16) = SGN(C15 - XAVGC13.16)) * SGN(C15 - XAVGC13.16) + ABS(SGN(119 * C15 + 765 * XAVGC12.16 - 65 * XAVGC26.16 - 819 * XAVGC9.16) <> SGN(C15 - XAVGC13.16)) * (ABS(SGN(119 * C16 + 765 * XAVGC12.17 - 65 * XAVGC26.17 - 819 * XAVGC9.17) = SGN(C16 - XAVGC13.17)) * SGN(C16 - XAVGC13.17) + ABS(SGN(119 * C16 + 765 * XAVGC12.17 - 65 * XAVGC26.17 - 819 * XAVGC9.17) <> SGN(C16 - XAVGC13.17)) * (ABS(SGN(119 * C17 + 765 * XAVGC12.18 - 65 * XAVGC26.18 - 819 * XAVGC9.18) = SGN(C17 - XAVGC13.18)) * SGN(C17 - XAVGC13.18) + ABS(SGN(119 * C17 + 765 * XAVGC12.18 - 65 * XAVGC26.18 - 819 * XAVGC9.18) <> SGN(C17 - XAVGC13.18)) * (ABS(SGN(119 * C18 + 765 * XAVGC12.19 - 65 * XAVGC26.19 - 819 * XAVGC9.19) = SGN(C18 - XAVGC13.19)) * SGN(C18 - XAVGC13.19) + ABS(SGN(119 * C18 + 765 * XAVGC12.19 - 65 * XAVGC26.19 - 819 * XAVGC9.19) <> SGN(C18 - XAVGC13.19)) * (ABS(SGN(119 * C19 + 765 * XAVGC12.20 - 65 * XAVGC26.20 - 819 * XAVGC9.20) = SGN(C19 - XAVGC13.20)) * SGN(C19 - XAVGC13.20) + ABS(SGN(119 * C19 + 765 * XAVGC12.20 - 65 * XAVGC26.20 - 819 * XAVGC9.20) <> SGN(C19 - XAVGC13.20)) * (ABS(SGN(119 * C20 + 765 * XAVGC12.21 - 65 * XAVGC26.21 - 819 * XAVGC9.21) = SGN(C20 - XAVGC13.21)) * SGN(C20 - XAVGC13.21) + ABS(SGN(119 * C20 + 765 * XAVGC12.21 - 65 * XAVGC26.21 - 819 * XAVGC9.21) <> SGN(C20 - XAVGC13.21)) * (ABS(SGN(119 * C21 + 765 * XAVGC12.22 - 65 * XAVGC26.22 - 819 * XAVGC9.22) = SGN(C21 - XAVGC13.22)) * SGN(C21 - XAVGC13.22) + ABS(SGN(119 * C21 + 765 * XAVGC12.22 - 65 * XAVGC26.22 - 819 * XAVGC9.22) <> SGN(C21 - XAVGC13.22)) * (ABS(SGN(119 * C22 + 765 * XAVGC12.23 - 65 * XAVGC26.23 - 819 * XAVGC9.23) = SGN(C22 - XAVGC13.23)) * SGN(C22 - XAVGC13.23) + ABS(SGN(119 * C22 + 765 * XAVGC12.23 - 65 * XAVGC26.23 - 819 * XAVGC9.23) <> SGN(C22 - XAVGC13.23)) * (ABS(SGN(119 * C23 + 765 * XAVGC12.24 - 65 * XAVGC26.24 - 819 * XAVGC9.24) = SGN(C23 - XAVGC13.24)) * SGN(C23 - XAVGC13.24) + ABS(SGN(119 * C23 + 765 * XAVGC12.24 - 65 * XAVGC26.24 - 819 * XAVGC9.24) <> SGN(C23 - XAVGC13.24)) * (ABS(SGN(119 * C24 + 765 * XAVGC12.25 - 65 * XAVGC26.25 - 819 * XAVGC9.25) = SGN(C24 - XAVGC13.25)) * SGN(C24 - XAVGC13.25) + ABS(SGN(119 * C24 + 765 * XAVGC12.25 - 65 * XAVGC26.25 - 819 * XAVGC9.25) <> SGN(C24 - XAVGC13.25)) * (ABS(SGN(119 * C25 + 765 * XAVGC12.26 - 65 * XAVGC26.26 - 819 * XAVGC9.26) = SGN(C25 - XAVGC13.26)) * SGN(C25 - XAVGC13.26))))))))))))))))))))))))) < 0

For Non-Downtrend is true and Uptrend more recent than Downtrend.

(C > XAVGC13.1 OR 119 * C + 765 * XAVGC12.1 > 65 * XAVGC26.1 + 819 * XAVGC9.1) AND ABS(SGN(119 * C1 + 765 * XAVGC12.2 - 65 * XAVGC26.2 - 819 * XAVGC9.2) = SGN(C1 - XAVGC13.2)) * SGN(C1 - XAVGC13.2) + ABS(SGN(119 * C1 + 765 * XAVGC12.2 - 65 * XAVGC26.2 - 819 * XAVGC9.2) <> SGN(C1 - XAVGC13.2)) * (ABS(SGN(119 * C2 + 765 * XAVGC12.3 - 65 * XAVGC26.3 - 819 * XAVGC9.3) = SGN(C2 - XAVGC13.3)) * SGN(C2 - XAVGC13.3) + ABS(SGN(119 * C2 + 765 * XAVGC12.3 - 65 * XAVGC26.3 - 819 * XAVGC9.3) <> SGN(C2 - XAVGC13.3)) * (ABS(SGN(119 * C3 + 765 * XAVGC12.4 - 65 * XAVGC26.4 - 819 * XAVGC9.4) = SGN(C3 - XAVGC13.4)) * SGN(C3 - XAVGC13.4) + ABS(SGN(119 * C3 + 765 * XAVGC12.4 - 65 * XAVGC26.4 - 819 * XAVGC9.4) <> SGN(C3 - XAVGC13.4)) * (ABS(SGN(119 * C4 + 765 * XAVGC12.5 - 65 * XAVGC26.5 - 819 * XAVGC9.5) = SGN(C4 - XAVGC13.5)) * SGN(C4 - XAVGC13.5) + ABS(SGN(119 * C4 + 765 * XAVGC12.5 - 65 * XAVGC26.5 - 819 * XAVGC9.5) <> SGN(C4 - XAVGC13.5)) * (ABS(SGN(119 * C5 + 765 * XAVGC12.6 - 65 * XAVGC26.6 - 819 * XAVGC9.6) = SGN(C5 - XAVGC13.6)) * SGN(C5 - XAVGC13.6) + ABS(SGN(119 * C5 + 765 * XAVGC12.6 - 65 * XAVGC26.6 - 819 * XAVGC9.6) <> SGN(C5 - XAVGC13.6)) * (ABS(SGN(119 * C6 + 765 * XAVGC12.7 - 65 * XAVGC26.7 - 819 * XAVGC9.7) = SGN(C6 - XAVGC13.7)) * SGN(C6 - XAVGC13.7) + ABS(SGN(119 * C6 + 765 * XAVGC12.7 - 65 * XAVGC26.7 - 819 * XAVGC9.7) <> SGN(C6 - XAVGC13.7)) * (ABS(SGN(119 * C7 + 765 * XAVGC12.8 - 65 * XAVGC26.8 - 819 * XAVGC9.8) = SGN(C7 - XAVGC13.8)) * SGN(C7 - XAVGC13.8) + ABS(SGN(119 * C7 + 765 * XAVGC12.8 - 65 * XAVGC26.8 - 819 * XAVGC9.8) <> SGN(C7 - XAVGC13.8)) * (ABS(SGN(119 * C8 + 765 * XAVGC12.9 - 65 * XAVGC26.9 - 819 * XAVGC9.9) = SGN(C8 - XAVGC13.9)) * SGN(C8 - XAVGC13.9) + ABS(SGN(119 * C8 + 765 * XAVGC12.9 - 65 * XAVGC26.9 - 819 * XAVGC9.9) <> SGN(C8 - XAVGC13.9)) * (ABS(SGN(119 * C9 + 765 * XAVGC12.10 - 65 * XAVGC26.10 - 819 * XAVGC9.10) = SGN(C9 - XAVGC13.10)) * SGN(C9 - XAVGC13.10) + ABS(SGN(119 * C9 + 765 * XAVGC12.10 - 65 * XAVGC26.10 - 819 * XAVGC9.10) <> SGN(C9 - XAVGC13.10)) * (ABS(SGN(119 * C10 + 765 * XAVGC12.11 - 65 * XAVGC26.11 - 819 * XAVGC9.11) = SGN(C10 - XAVGC13.11)) * SGN(C10 - XAVGC13.11) + ABS(SGN(119 * C10 + 765 * XAVGC12.11 - 65 * XAVGC26.11 - 819 * XAVGC9.11) <> SGN(C10 - XAVGC13.11)) * (ABS(SGN(119 * C11 + 765 * XAVGC12.12 - 65 * XAVGC26.12 - 819 * XAVGC9.12) = SGN(C11 - XAVGC13.12)) * SGN(C11 - XAVGC13.12) + ABS(SGN(119 * C11 + 765 * XAVGC12.12 - 65 * XAVGC26.12 - 819 * XAVGC9.12) <> SGN(C11 - XAVGC13.12)) * (ABS(SGN(119 * C12 + 765 * XAVGC12.13 - 65 * XAVGC26.13 - 819 * XAVGC9.13) = SGN(C12 - XAVGC13.13)) * SGN(C12 - XAVGC13.13) + ABS(SGN(119 * C12 + 765 * XAVGC12.13 - 65 * XAVGC26.13 - 819 * XAVGC9.13) <> SGN(C12 - XAVGC13.13)) * (ABS(SGN(119 * C13 + 765 * XAVGC12.14 - 65 * XAVGC26.14 - 819 * XAVGC9.14) = SGN(C13 - XAVGC13.14)) * SGN(C13 - XAVGC13.14) + ABS(SGN(119 * C13 + 765 * XAVGC12.14 - 65 * XAVGC26.14 - 819 * XAVGC9.14) <> SGN(C13 - XAVGC13.14)) * (ABS(SGN(119 * C14 + 765 * XAVGC12.15 - 65 * XAVGC26.15 - 819 * XAVGC9.15) = SGN(C14 - XAVGC13.15)) * SGN(C14 - XAVGC13.15) + ABS(SGN(119 * C14 + 765 * XAVGC12.15 - 65 * XAVGC26.15 - 819 * XAVGC9.15) <> SGN(C14 - XAVGC13.15)) * (ABS(SGN(119 * C15 + 765 * XAVGC12.16 - 65 * XAVGC26.16 - 819 * XAVGC9.16) = SGN(C15 - XAVGC13.16)) * SGN(C15 - XAVGC13.16) + ABS(SGN(119 * C15 + 765 * XAVGC12.16 - 65 * XAVGC26.16 - 819 * XAVGC9.16) <> SGN(C15 - XAVGC13.16)) * (ABS(SGN(119 * C16 + 765 * XAVGC12.17 - 65 * XAVGC26.17 - 819 * XAVGC9.17) = SGN(C16 - XAVGC13.17)) * SGN(C16 - XAVGC13.17) + ABS(SGN(119 * C16 + 765 * XAVGC12.17 - 65 * XAVGC26.17 - 819 * XAVGC9.17) <> SGN(C16 - XAVGC13.17)) * (ABS(SGN(119 * C17 + 765 * XAVGC12.18 - 65 * XAVGC26.18 - 819 * XAVGC9.18) = SGN(C17 - XAVGC13.18)) * SGN(C17 - XAVGC13.18) + ABS(SGN(119 * C17 + 765 * XAVGC12.18 - 65 * XAVGC26.18 - 819 * XAVGC9.18) <> SGN(C17 - XAVGC13.18)) * (ABS(SGN(119 * C18 + 765 * XAVGC12.19 - 65 * XAVGC26.19 - 819 * XAVGC9.19) = SGN(C18 - XAVGC13.19)) * SGN(C18 - XAVGC13.19) + ABS(SGN(119 * C18 + 765 * XAVGC12.19 - 65 * XAVGC26.19 - 819 * XAVGC9.19) <> SGN(C18 - XAVGC13.19)) * (ABS(SGN(119 * C19 + 765 * XAVGC12.20 - 65 * XAVGC26.20 - 819 * XAVGC9.20) = SGN(C19 - XAVGC13.20)) * SGN(C19 - XAVGC13.20) + ABS(SGN(119 * C19 + 765 * XAVGC12.20 - 65 * XAVGC26.20 - 819 * XAVGC9.20) <> SGN(C19 - XAVGC13.20)) * (ABS(SGN(119 * C20 + 765 * XAVGC12.21 - 65 * XAVGC26.21 - 819 * XAVGC9.21) = SGN(C20 - XAVGC13.21)) * SGN(C20 - XAVGC13.21) + ABS(SGN(119 * C20 + 765 * XAVGC12.21 - 65 * XAVGC26.21 - 819 * XAVGC9.21) <> SGN(C20 - XAVGC13.21)) * (ABS(SGN(119 * C21 + 765 * XAVGC12.22 - 65 * XAVGC26.22 - 819 * XAVGC9.22) = SGN(C21 - XAVGC13.22)) * SGN(C21 - XAVGC13.22) + ABS(SGN(119 * C21 + 765 * XAVGC12.22 - 65 * XAVGC26.22 - 819 * XAVGC9.22) <> SGN(C21 - XAVGC13.22)) * (ABS(SGN(119 * C22 + 765 * XAVGC12.23 - 65 * XAVGC26.23 - 819 * XAVGC9.23) = SGN(C22 - XAVGC13.23)) * SGN(C22 - XAVGC13.23) + ABS(SGN(119 * C22 + 765 * XAVGC12.23 - 65 * XAVGC26.23 - 819 * XAVGC9.23) <> SGN(C22 - XAVGC13.23)) * (ABS(SGN(119 * C23 + 765 * XAVGC12.24 - 65 * XAVGC26.24 - 819 * XAVGC9.24) = SGN(C23 - XAVGC13.24)) * SGN(C23 - XAVGC13.24) + ABS(SGN(119 * C23 + 765 * XAVGC12.24 - 65 * XAVGC26.24 - 819 * XAVGC9.24) <> SGN(C23 - XAVGC13.24)) * (ABS(SGN(119 * C24 + 765 * XAVGC12.25 - 65 * XAVGC26.25 - 819 * XAVGC9.25) = SGN(C24 - XAVGC13.25)) * SGN(C24 - XAVGC13.25) + ABS(SGN(119 * C24 + 765 * XAVGC12.25 - 65 * XAVGC26.25 - 819 * XAVGC9.25) <> SGN(C24 - XAVGC13.25)) * (ABS(SGN(119 * C25 + 765 * XAVGC12.26 - 65 * XAVGC26.26 - 819 * XAVGC9.26) = SGN(C25 - XAVGC13.26)) * SGN(C25 - XAVGC13.26))))))))))))))))))))))))) > 0

I tried the formula for Volume: V>=XAVG20 and keep getting a formula error message. What am I missing?

Lothar

You are missing the second V. The Condition Formula should actually be the following.

V >= XAVGV20

Got it! Can't believe I missed that...

Thanks!

You're welcome.