Registered User Joined: 9/7/2014 Posts: 36
|
How would I write a formula for
xavgc12 was less than xavgc50 from 1 day ago to 50 days ago. AND
xavgc12 is greater than xavgc50 today
Thanks for your anticipated help
Respectfully
|
Registered User Joined: 9/17/2010 Posts: 484
|
The second is straight forward
XAvgC12>XAvgC50
First is a bit trickier
CountTrue(XAvgC12.1<XAvgC50.1,50)=50
Just put "AND" between them
|
Registered User Joined: 9/7/2014 Posts: 36
|
Thank you very much.
|