| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 3/26/2012
Posts: 45
|
I have the PCF to get the range for each of the last 5 days:
H1*100/L1-100
H2*100/L2-100
H3*100/L3-100
H4*100/L4-100
H5*100/L5-100
However, what would be the PCF to get the average of these?
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You need to add it all together and then divide by 5:
100 * ((H1 / L1 + H2 / L2 + H3 / L3 + H4 / L4 + H5 / L5) / 5 - 1)
You could also just average the highs and lows to get a shorter formula, but it would not exactly match because if the division in each term:
100 * (AVGH5.1 / AVGL5.1 - 1)
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 3/26/2012
Posts: 45
|
Would this be it?
(H1*100/L1-100) + (H2*100/L2-100) + (H3*100/L3-100) + (H4*100/L4-100) + (H5*100/L5-100) /5
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You would need to re-arrange the parantheses to make your version work correctly:
(H1*100/L1-100 + H2*100/L2-100 + H3*100/L3-100 + H4*100/L4-100 + H5*100/L5-100) /5
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 3/26/2012
Posts: 45
|
Ah, okay...excellent. Thanks so much, Bruce!
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |