Registered User Joined: 4/7/2011 Posts: 69
|
Hello,
I am trying to simplify a condition. the complete formula would have 100 lines, here is the abbreviated version:
(ABS((C*100) / C1 -100) +
ABS((C1*100) / C2 -100) +
ABS((C2*100) / C3 -100) +
ABS((C3*100) / C4 -100) +
...
ABS((C99*100) / C100 -100)
)/100 > 1.98
where the "..." are all the lines in between C3 and C99
would there be a way to simplify this so i don't have to type 1oo lines?
Thanks!
|
Registered User Joined: 1/28/2005 Posts: 6,049
|
I believe this is what you want:
AVG(ABS((C*100) / C1 -100),100)>1.98
Thanks
|
Registered User Joined: 4/7/2011 Posts: 69
|
Will try it. Thanks!
|