| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 9/30/2011
Posts: 788
|
I would like to modify the following PCF Formula with the new parameter:
100 * (C / (H1 + 2 * ((H1 + L1 + C1) / 3 - L1)) - 1)
The signal on the symbols with the value => of -5% up.
Thank you and goodbye.
Raider45
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
I don't understand what you are asking. Do you just want the formula to be greater than or equal to negative five?
100 * (C / (H1 + 2 * ((H1 + L1 + C1) / 3 - L1)) - 1) >= -5
Or maybe be crossing up through negative five?
XUP(100 * (C / (H1 + 2 * ((H1 + L1 + C1) / 3 - L1)) - 1), -5)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 9/30/2011
Posts: 788
|
The two formulas do not correspond to the requirements
Having different values, the signal must be on the following symboly, discarding those with values below -5%
- 4
- 18
- 11
- 8
- 10.5
- 2
- 9.7
- 1.8
- 0.25
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
If I am understanding correctly, the first formula correspond to the exact opposite of your requirements, but it really was my best guess based on the grammar and construction of the original request.
Please try the following condition formula instead (it just reversed the > sign to a < sign in the formula).
100 * (C / (H1 + 2 * ((H1 + L1 + C1) / 3 - L1)) - 1) <= -5
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 9/30/2011
Posts: 788
|
The new formula works perfectly, congratulations and thanks !
Best regards !
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |