Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Simplification of condition Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
mcubas
Posted : Saturday, June 3, 2017 6:54:08 PM
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!
diceman
Posted : Saturday, June 3, 2017 11:02:34 PM
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

 

 

mcubas
Posted : Sunday, June 4, 2017 5:04:41 PM
Registered User
Joined: 4/7/2011
Posts: 69

Will try it. Thanks!

Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.