Registered User Joined: 8/15/2011 Posts: 11
|
hey Bruce, you built this formula for me. What I want to do is built a column that track the % change from this day forward. Like the Trk% build already in the TC2000
.10 + ABS(AVGC10 > AVGC50 AND AVGC10.1 <= AVGC50.1) * H + ABS(AVGC10 <= AVGC50 OR AVGC10.1 > AVGC50.1) * (ABS(AVGC10.1 > AVGC50.1 AND AVGC10.2 <= AVGC50.2) * H1 + ABS(AVGC10.1 <= AVGC50.1 OR AVGC10.2 > AVGC50.2) * (ABS(AVGC10.2 > AVGC50.2 AND AVGC10.3 <= AVGC50.3) * H2 + ABS(AVGC10.2 <= AVGC50.2 OR AVGC10.3 > AVGC50.3) * (ABS(AVGC10.3 > AVGC50.3 AND AVGC10.4 <= AVGC50.4) * H3 + ABS(AVGC10.3 <= AVGC50.3 OR AVGC10.4 > AVGC50.4) * (ABS(AVGC10.4 > AVGC50.4 AND AVGC10.5 <= AVGC50.5) * H4 + ABS(AVGC10.4 <= AVGC50.4 OR AVGC10.5 > AVGC50.5) * (ABS(AVGC10.5 > AVGC50.5 AND AVGC10.6 <= AVGC50.6) * H5 + ABS(AVGC10.5 <= AVGC50.5 OR AVGC10.6 > AVGC50.6) * (ABS(AVGC10.6 > AVGC50.6 AND AVGC10.7 <= AVGC50.7) * H6 + ABS(AVGC10.6 <= AVGC50.6 OR AVGC10.7 > AVGC50.7) * (ABS(AVGC10.7 > AVGC50.7 AND AVGC10.8 <= AVGC50.8) * H7 + ABS(AVGC10.7 <= AVGC50.7 OR AVGC10.8 > AVGC50.8) * (ABS(AVGC10.8 > AVGC50.8 AND AVGC10.9 <= AVGC50.9) * H8 + ABS(AVGC10.8 <= AVGC50.8 OR AVGC10.9 > AVGC50.9) * (ABS(AVGC10.9 > AVGC50.9 AND AVGC10.10 <= AVGC50.10) * H9 + ABS(AVGC10.9 <= AVGC50.9 OR AVGC10.10 > AVGC50.10) * (ABS(AVGC10.10 > AVGC50.10 AND AVGC10.11 <= AVGC50.11) * H10 + ABS(AVGC10.10 <= AVGC50.10 OR AVGC10.11 > AVGC50.11) * (ABS(AVGC10.11 > AVGC50.11 AND AVGC10.12 <= AVGC50.12) * H11 + ABS(AVGC10.11 <= AVGC50.11 OR AVGC10.12 > AVGC50.12) * (ABS(AVGC10.12 > AVGC50.12 AND AVGC10.13 <= AVGC50.13) * H12 + ABS(AVGC10.12 <= AVGC50.12 OR AVGC10.13 > AVGC50.13) * (ABS(AVGC10.13 > AVGC50.13 AND AVGC10.14 <= AVGC50.14) * H13 + ABS(AVGC10.13 <= AVGC50.13 OR AVGC10.14 > AVGC50.14) * (ABS(AVGC10.14 > AVGC50.14 AND AVGC10.15 <= AVGC50.15) * H14 + ABS(AVGC10.14 <= AVGC50.14 OR AVGC10.15 > AVGC50.15) * (ABS(AVGC10.15 > AVGC50.15 AND AVGC10.16 <= AVGC50.16) * H15 + ABS(AVGC10.15 <= AVGC50.15 OR AVGC10.16 > AVGC50.16) * (ABS(AVGC10.16 > AVGC50.16 AND AVGC10.17 <= AVGC50.17) * H16 + ABS(AVGC10.16 <= AVGC50.16 OR AVGC10.17 > AVGC50.17) * (ABS(AVGC10.17 > AVGC50.17 AND AVGC10.18 <= AVGC50.18) * H17 + ABS(AVGC10.17 <= AVGC50.17 OR AVGC10.18 > AVGC50.18) * (ABS(AVGC10.18 > AVGC50.18 AND AVGC10.19 <= AVGC50.19) * H18 + ABS(AVGC10.18 <= AVGC50.18 OR AVGC10.19 > AVGC50.19) * (ABS(AVGC10.19 > AVGC50.19 AND AVGC10.20 <= AVGC50.20) * H19 + ABS(AVGC10.19 <= AVGC50.19 OR AVGC10.20 > AVGC50.20) * (ABS(AVGC10.20 > AVGC50.20 AND AVGC10.21 <= AVGC50.21) * H20 + ABS(AVGC10.20 <= AVGC50.20 OR AVGC10.21 > AVGC50.21) * (ABS(AVGC10.21 > AVGC50.21 AND AVGC10.22 <= AVGC50.22) * H21 + ABS(AVGC10.21 <= AVGC50.21 OR AVGC10.22 > AVGC50.22) * (ABS(AVGC10.22 > AVGC50.22 AND AVGC10.23 <= AVGC50.23) * H22 + ABS(AVGC10.22 <= AVGC50.22 OR AVGC10.23 > AVGC50.23) * (ABS(AVGC10.23 > AVGC50.23 AND AVGC10.24 <= AVGC50.24) * H23 + ABS(AVGC10.23 <= AVGC50.23 OR AVGC10.24 > AVGC50.24) * (ABS(AVGC10.24 > AVGC50.24 AND AVGC10.25 <= AVGC50.25) * H24 + ABS(AVGC10.24 <= AVGC50.24 OR AVGC10.25 > AVGC50.25) * (ABS(AVGC10.25 > AVGC50.25 AND AVGC10.26 <= AVGC50.26) * H25 + ABS(AVGC10.25 <= AVGC50.25 OR AVGC10.26 > AVGC50.26) * (ABS(AVGC10.26 > AVGC50.26 AND AVGC10.27 <= AVGC50.27) * H26 + ABS(AVGC10.26 <= AVGC50.26 OR AVGC10.27 > AVGC50.27) * (ABS(AVGC10.27 > AVGC50.27 AND AVGC10.28 <= AVGC50.28) * H27 + ABS(AVGC10.27 <= AVGC50.27 OR AVGC10.28 > AVGC50.28) * (ABS(AVGC10.28 > AVGC50.28 AND AVGC10.29 <= AVGC50.29) * H28 + ABS(AVGC10.28 <= AVGC50.28 OR AVGC10.29 > AVGC50.29) * (ABS(AVGC10.29 > AVGC50.29 AND AVGC10.30 <= AVGC50.30) * H29 + ABS(AVGC10.29 <= AVGC50.29 OR AVGC10.30 > AVGC50.30) * (ABS(AVGC10.30 > AVGC50.30 AND AVGC10.31 <= AVGC50.31) * H30 + ABS(AVGC10.30 <= AVGC50.30 OR AVGC10.31 > AVGC50.31) * (ABS(AVGC10.31 > AVGC50.31 AND AVGC10.32 <= AVGC50.32) * H31 + ABS(AVGC10.31 <= AVGC50.31 OR AVGC10.32 > AVGC50.32) * (ABS(AVGC10.32 > AVGC50.32 AND AVGC10.33 <= AVGC50.33) * H32 + ABS(AVGC10.32 <= AVGC50.32 OR AVGC10.33 > AVGC50.33) * (ABS(AVGC10.33 > AVGC50.33 AND AVGC10.34 <= AVGC50.34) * H33 + ABS(AVGC10.33 <= AVGC50.33 OR AVGC10.34 > AVGC50.34) * (ABS(AVGC10.34 > AVGC50.34 AND AVGC10.35 <= AVGC50.35) * H34 + ABS(AVGC10.34 <= AVGC50.34 OR AVGC10.35 > AVGC50.35) * (ABS(AVGC10.35 > AVGC50.35 AND AVGC10.36 <= AVGC50.36) * H35 + ABS(AVGC10.35 <= AVGC50.35 OR AVGC10.36 > AVGC50.36) * (ABS(AVGC10.36 > AVGC50.36 AND AVGC10.37 <= AVGC50.37) * H36 + ABS(AVGC10.36 <= AVGC50.36 OR AVGC10.37 > AVGC50.37) * (ABS(AVGC10.37 > AVGC50.37 AND AVGC10.38 <= AVGC50.38) * H37 + ABS(AVGC10.37 <= AVGC50.37 OR AVGC10.38 > AVGC50.38) * (ABS(AVGC10.38 > AVGC50.38 AND AVGC10.39 <= AVGC50.39) * H38 + ABS(AVGC10.38 <= AVGC50.38 OR AVGC10.39 > AVGC50.39) * (ABS(AVGC10.39 > AVGC50.39 AND AVGC10.40 <= AVGC50.40) * H39 + ABS(AVGC10.39 <= AVGC50.39 OR AVGC10.40 > AVGC50.40) * (ABS(AVGC10.40 > AVGC50.40 AND AVGC10.41 <= AVGC50.41) * H40 + ABS(AVGC10.40 <= AVGC50.40 OR AVGC10.41 > AVGC50.41) * (ABS(AVGC10.41 > AVGC50.41 AND AVGC10.42 <= AVGC50.42) * H41 + ABS(AVGC10.41 <= AVGC50.41 OR AVGC10.42 > AVGC50.42) * (ABS(AVGC10.42 > AVGC50.42 AND AVGC10.43 <= AVGC50.43) * H42 + ABS(AVGC10.42 <= AVGC50.42 OR AVGC10.43 > AVGC50.43) * (ABS(AVGC10.43 > AVGC50.43 AND AVGC10.44 <= AVGC50.44) * H43 + ABS(AVGC10.43 <= AVGC50.43 OR AVGC10.44 > AVGC50.44) * (ABS(AVGC10.44 > AVGC50.44 AND AVGC10.45 <= AVGC50.45) * H44 + ABS(AVGC10.44 <= AVGC50.44 OR AVGC10.45 > AVGC50.45) * (ABS(AVGC10.45 > AVGC50.45 AND AVGC10.46 <= AVGC50.46) * H45 + ABS(AVGC10.45 <= AVGC50.45 OR AVGC10.46 > AVGC50.46) * (ABS(AVGC10.46 > AVGC50.46 AND AVGC10.47 <= AVGC50.47) * H46 + ABS(AVGC10.46 <= AVGC50.46 OR AVGC10.47 > AVGC50.47) * (ABS(AVGC10.47 > AVGC50.47 AND AVGC10.48 <= AVGC50.48) * H47 + ABS(AVGC10.47 <= AVGC50.47 OR AVGC10.48 > AVGC50.48) * (ABS(AVGC10.48 > AVGC50.48 AND AVGC10.49 <= AVGC50.49) * H48 + ABS(AVGC10.48 <= AVGC50.48 OR AVGC10.49 > AVGC50.49) * (ABS(AVGC10.49 > AVGC50.49 AND AVGC10.50 <= AVGC50.50) * H49 + ABS(AVGC10.49 <= AVGC50.49 OR AVGC10.50 > AVGC50.50) * (ABS(AVGC10.50 > AVGC50.50 AND AVGC10.51 <= AVGC50.51) * H50 + ABS(AVGC10.50 <= AVGC50.50 OR AVGC10.51 > AVGC50.51) * (ABS(AVGC10.51 > AVGC50.51 AND AVGC10.52 <= AVGC50.52) * H51 + ABS(AVGC10.51 <= AVGC50.51 OR AVGC10.52 > AVGC50.52) * (ABS(AVGC10.52 > AVGC50.52 AND AVGC10.53 <= AVGC50.53) * H52 + ABS(AVGC10.52 <= AVGC50.52 OR AVGC10.53 > AVGC50.53) * (ABS(AVGC10.53 > AVGC50.53 AND AVGC10.54 <= AVGC50.54) * H53 + ABS(AVGC10.53 <= AVGC50.53 OR AVGC10.54 > AVGC50.54) * (ABS(AVGC10.54 > AVGC50.54 AND AVGC10.55 <= AVGC50.55) * H54 + ABS(AVGC10.54 <= AVGC50.54 OR AVGC10.55 > AVGC50.55) * (ABS(AVGC10.55 > AVGC50.55 AND AVGC10.56 <= AVGC50.56) * H55 + ABS(AVGC10.55 <= AVGC50.55 OR AVGC10.56 > AVGC50.56) * (ABS(AVGC10.56 > AVGC50.56 AND AVGC10.57 <= AVGC50.57) * H56 + ABS(AVGC10.56 <= AVGC50.56 OR AVGC10.57 > AVGC50.57) * (ABS(AVGC10.57 > AVGC50.57 AND AVGC10.58 <= AVGC50.58) * H57 + ABS(AVGC10.57 <= AVGC50.57 OR AVGC10.58 > AVGC50.58) * (ABS(AVGC10.58 > AVGC50.58 AND AVGC10.59 <= AVGC50.59) * H58 + ABS(AVGC10.58 <= AVGC50.58 OR AVGC10.59 > AVGC50.59) * (ABS(AVGC10.59 > AVGC50.59 AND AVGC10.60 <= AVGC50.60) * H59)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
The formula returns a numeric value and is not a condition in and of itself (although it does use a lot of conditions for its calculation).
If you wanted to plot the price percent change from the high being returned by the formula (doesn't include the + .10 portion):
100 * (C / (ABS(AVGC10 > AVGC50 AND AVGC10.1 <= AVGC50.1) * H + ABS(AVGC10 <= AVGC50 OR AVGC10.1 > AVGC50.1) * (ABS(AVGC10.1 > AVGC50.1 AND AVGC10.2 <= AVGC50.2) * H1 + ABS(AVGC10.1 <= AVGC50.1 OR AVGC10.2 > AVGC50.2) * (ABS(AVGC10.2 > AVGC50.2 AND AVGC10.3 <= AVGC50.3) * H2 + ABS(AVGC10.2 <= AVGC50.2 OR AVGC10.3 > AVGC50.3) * (ABS(AVGC10.3 > AVGC50.3 AND AVGC10.4 <= AVGC50.4) * H3 + ABS(AVGC10.3 <= AVGC50.3 OR AVGC10.4 > AVGC50.4) * (ABS(AVGC10.4 > AVGC50.4 AND AVGC10.5 <= AVGC50.5) * H4 + ABS(AVGC10.4 <= AVGC50.4 OR AVGC10.5 > AVGC50.5) * (ABS(AVGC10.5 > AVGC50.5 AND AVGC10.6 <= AVGC50.6) * H5 + ABS(AVGC10.5 <= AVGC50.5 OR AVGC10.6 > AVGC50.6) * (ABS(AVGC10.6 > AVGC50.6 AND AVGC10.7 <= AVGC50.7) * H6 + ABS(AVGC10.6 <= AVGC50.6 OR AVGC10.7 > AVGC50.7) * (ABS(AVGC10.7 > AVGC50.7 AND AVGC10.8 <= AVGC50.8) * H7 + ABS(AVGC10.7 <= AVGC50.7 OR AVGC10.8 > AVGC50.8) * (ABS(AVGC10.8 > AVGC50.8 AND AVGC10.9 <= AVGC50.9) * H8 + ABS(AVGC10.8 <= AVGC50.8 OR AVGC10.9 > AVGC50.9) * (ABS(AVGC10.9 > AVGC50.9 AND AVGC10.10 <= AVGC50.10) * H9 + ABS(AVGC10.9 <= AVGC50.9 OR AVGC10.10 > AVGC50.10) * (ABS(AVGC10.10 > AVGC50.10 AND AVGC10.11 <= AVGC50.11) * H10 + ABS(AVGC10.10 <= AVGC50.10 OR AVGC10.11 > AVGC50.11) * (ABS(AVGC10.11 > AVGC50.11 AND AVGC10.12 <= AVGC50.12) * H11 + ABS(AVGC10.11 <= AVGC50.11 OR AVGC10.12 > AVGC50.12) * (ABS(AVGC10.12 > AVGC50.12 AND AVGC10.13 <= AVGC50.13) * H12 + ABS(AVGC10.12 <= AVGC50.12 OR AVGC10.13 > AVGC50.13) * (ABS(AVGC10.13 > AVGC50.13 AND AVGC10.14 <= AVGC50.14) * H13 + ABS(AVGC10.13 <= AVGC50.13 OR AVGC10.14 > AVGC50.14) * (ABS(AVGC10.14 > AVGC50.14 AND AVGC10.15 <= AVGC50.15) * H14 + ABS(AVGC10.14 <= AVGC50.14 OR AVGC10.15 > AVGC50.15) * (ABS(AVGC10.15 > AVGC50.15 AND AVGC10.16 <= AVGC50.16) * H15 + ABS(AVGC10.15 <= AVGC50.15 OR AVGC10.16 > AVGC50.16) * (ABS(AVGC10.16 > AVGC50.16 AND AVGC10.17 <= AVGC50.17) * H16 + ABS(AVGC10.16 <= AVGC50.16 OR AVGC10.17 > AVGC50.17) * (ABS(AVGC10.17 > AVGC50.17 AND AVGC10.18 <= AVGC50.18) * H17 + ABS(AVGC10.17 <= AVGC50.17 OR AVGC10.18 > AVGC50.18) * (ABS(AVGC10.18 > AVGC50.18 AND AVGC10.19 <= AVGC50.19) * H18 + ABS(AVGC10.18 <= AVGC50.18 OR AVGC10.19 > AVGC50.19) * (ABS(AVGC10.19 > AVGC50.19 AND AVGC10.20 <= AVGC50.20) * H19 + ABS(AVGC10.19 <= AVGC50.19 OR AVGC10.20 > AVGC50.20) * (ABS(AVGC10.20 > AVGC50.20 AND AVGC10.21 <= AVGC50.21) * H20 + ABS(AVGC10.20 <= AVGC50.20 OR AVGC10.21 > AVGC50.21) * (ABS(AVGC10.21 > AVGC50.21 AND AVGC10.22 <= AVGC50.22) * H21 + ABS(AVGC10.21 <= AVGC50.21 OR AVGC10.22 > AVGC50.22) * (ABS(AVGC10.22 > AVGC50.22 AND AVGC10.23 <= AVGC50.23) * H22 + ABS(AVGC10.22 <= AVGC50.22 OR AVGC10.23 > AVGC50.23) * (ABS(AVGC10.23 > AVGC50.23 AND AVGC10.24 <= AVGC50.24) * H23 + ABS(AVGC10.23 <= AVGC50.23 OR AVGC10.24 > AVGC50.24) * (ABS(AVGC10.24 > AVGC50.24 AND AVGC10.25 <= AVGC50.25) * H24 + ABS(AVGC10.24 <= AVGC50.24 OR AVGC10.25 > AVGC50.25) * (ABS(AVGC10.25 > AVGC50.25 AND AVGC10.26 <= AVGC50.26) * H25 + ABS(AVGC10.25 <= AVGC50.25 OR AVGC10.26 > AVGC50.26) * (ABS(AVGC10.26 > AVGC50.26 AND AVGC10.27 <= AVGC50.27) * H26 + ABS(AVGC10.26 <= AVGC50.26 OR AVGC10.27 > AVGC50.27) * (ABS(AVGC10.27 > AVGC50.27 AND AVGC10.28 <= AVGC50.28) * H27 + ABS(AVGC10.27 <= AVGC50.27 OR AVGC10.28 > AVGC50.28) * (ABS(AVGC10.28 > AVGC50.28 AND AVGC10.29 <= AVGC50.29) * H28 + ABS(AVGC10.28 <= AVGC50.28 OR AVGC10.29 > AVGC50.29) * (ABS(AVGC10.29 > AVGC50.29 AND AVGC10.30 <= AVGC50.30) * H29 + ABS(AVGC10.29 <= AVGC50.29 OR AVGC10.30 > AVGC50.30) * (ABS(AVGC10.30 > AVGC50.30 AND AVGC10.31 <= AVGC50.31) * H30 + ABS(AVGC10.30 <= AVGC50.30 OR AVGC10.31 > AVGC50.31) * (ABS(AVGC10.31 > AVGC50.31 AND AVGC10.32 <= AVGC50.32) * H31 + ABS(AVGC10.31 <= AVGC50.31 OR AVGC10.32 > AVGC50.32) * (ABS(AVGC10.32 > AVGC50.32 AND AVGC10.33 <= AVGC50.33) * H32 + ABS(AVGC10.32 <= AVGC50.32 OR AVGC10.33 > AVGC50.33) * (ABS(AVGC10.33 > AVGC50.33 AND AVGC10.34 <= AVGC50.34) * H33 + ABS(AVGC10.33 <= AVGC50.33 OR AVGC10.34 > AVGC50.34) * (ABS(AVGC10.34 > AVGC50.34 AND AVGC10.35 <= AVGC50.35) * H34 + ABS(AVGC10.34 <= AVGC50.34 OR AVGC10.35 > AVGC50.35) * (ABS(AVGC10.35 > AVGC50.35 AND AVGC10.36 <= AVGC50.36) * H35 + ABS(AVGC10.35 <= AVGC50.35 OR AVGC10.36 > AVGC50.36) * (ABS(AVGC10.36 > AVGC50.36 AND AVGC10.37 <= AVGC50.37) * H36 + ABS(AVGC10.36 <= AVGC50.36 OR AVGC10.37 > AVGC50.37) * (ABS(AVGC10.37 > AVGC50.37 AND AVGC10.38 <= AVGC50.38) * H37 + ABS(AVGC10.37 <= AVGC50.37 OR AVGC10.38 > AVGC50.38) * (ABS(AVGC10.38 > AVGC50.38 AND AVGC10.39 <= AVGC50.39) * H38 + ABS(AVGC10.38 <= AVGC50.38 OR AVGC10.39 > AVGC50.39) * (ABS(AVGC10.39 > AVGC50.39 AND AVGC10.40 <= AVGC50.40) * H39 + ABS(AVGC10.39 <= AVGC50.39 OR AVGC10.40 > AVGC50.40) * (ABS(AVGC10.40 > AVGC50.40 AND AVGC10.41 <= AVGC50.41) * H40 + ABS(AVGC10.40 <= AVGC50.40 OR AVGC10.41 > AVGC50.41) * (ABS(AVGC10.41 > AVGC50.41 AND AVGC10.42 <= AVGC50.42) * H41 + ABS(AVGC10.41 <= AVGC50.41 OR AVGC10.42 > AVGC50.42) * (ABS(AVGC10.42 > AVGC50.42 AND AVGC10.43 <= AVGC50.43) * H42 + ABS(AVGC10.42 <= AVGC50.42 OR AVGC10.43 > AVGC50.43) * (ABS(AVGC10.43 > AVGC50.43 AND AVGC10.44 <= AVGC50.44) * H43 + ABS(AVGC10.43 <= AVGC50.43 OR AVGC10.44 > AVGC50.44) * (ABS(AVGC10.44 > AVGC50.44 AND AVGC10.45 <= AVGC50.45) * H44 + ABS(AVGC10.44 <= AVGC50.44 OR AVGC10.45 > AVGC50.45) * (ABS(AVGC10.45 > AVGC50.45 AND AVGC10.46 <= AVGC50.46) * H45 + ABS(AVGC10.45 <= AVGC50.45 OR AVGC10.46 > AVGC50.46) * (ABS(AVGC10.46 > AVGC50.46 AND AVGC10.47 <= AVGC50.47) * H46 + ABS(AVGC10.46 <= AVGC50.46 OR AVGC10.47 > AVGC50.47) * (ABS(AVGC10.47 > AVGC50.47 AND AVGC10.48 <= AVGC50.48) * H47 + ABS(AVGC10.47 <= AVGC50.47 OR AVGC10.48 > AVGC50.48) * (ABS(AVGC10.48 > AVGC50.48 AND AVGC10.49 <= AVGC50.49) * H48 + ABS(AVGC10.48 <= AVGC50.48 OR AVGC10.49 > AVGC50.49) * (ABS(AVGC10.49 > AVGC50.49 AND AVGC10.50 <= AVGC50.50) * H49 + ABS(AVGC10.49 <= AVGC50.49 OR AVGC10.50 > AVGC50.50) * (ABS(AVGC10.50 > AVGC50.50 AND AVGC10.51 <= AVGC50.51) * H50 + ABS(AVGC10.50 <= AVGC50.50 OR AVGC10.51 > AVGC50.51) * (ABS(AVGC10.51 > AVGC50.51 AND AVGC10.52 <= AVGC50.52) * H51 + ABS(AVGC10.51 <= AVGC50.51 OR AVGC10.52 > AVGC50.52) * (ABS(AVGC10.52 > AVGC50.52 AND AVGC10.53 <= AVGC50.53) * H52 + ABS(AVGC10.52 <= AVGC50.52 OR AVGC10.53 > AVGC50.53) * (ABS(AVGC10.53 > AVGC50.53 AND AVGC10.54 <= AVGC50.54) * H53 + ABS(AVGC10.53 <= AVGC50.53 OR AVGC10.54 > AVGC50.54) * (ABS(AVGC10.54 > AVGC50.54 AND AVGC10.55 <= AVGC50.55) * H54 + ABS(AVGC10.54 <= AVGC50.54 OR AVGC10.55 > AVGC50.55) * (ABS(AVGC10.55 > AVGC50.55 AND AVGC10.56 <= AVGC50.56) * H55 + ABS(AVGC10.55 <= AVGC50.55 OR AVGC10.56 > AVGC50.56) * (ABS(AVGC10.56 > AVGC50.56 AND AVGC10.57 <= AVGC50.57) * H56 + ABS(AVGC10.56 <= AVGC50.56 OR AVGC10.57 > AVGC50.57) * (ABS(AVGC10.57 > AVGC50.57 AND AVGC10.58 <= AVGC50.58) * H57 + ABS(AVGC10.57 <= AVGC50.57 OR AVGC10.58 > AVGC50.58) * (ABS(AVGC10.58 > AVGC50.58 AND AVGC10.59 <= AVGC50.59) * H58 + ABS(AVGC10.58 <= AVGC50.58 OR AVGC10.59 > AVGC50.59) * (ABS(AVGC10.59 > AVGC50.59 AND AVGC10.60 <= AVGC50.60) * H59)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) - 1)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|