Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 11/1/2010 Posts: 28
|
I have PCF BOP5>31 but it gives me something different than what I want.
I still get one green and 4 yellow BOP bars sometimes.
Julia or Michael said to enter this formula but I want 5 consecutive days of BOP
above 30 or 31. The current day or yesterday and the 4 before that. Not at any time
prior.
Thanks,
Fred
|
|
Registered User Joined: 10/23/2004 Posts: 251
|
Try this one. I tested it and it seems to work.
MIN(BOP,5) > 30
Does that help?
|
|
Registered User Joined: 11/1/2010 Posts: 28
|
Naresh,
I tried it and believe it is working as I had hoped.
Thanks,
Fred
|
|
Guest-1 |