Hi, Im looking for correct formula to use for below conditions using macros function


• Zone A – Average +/- one SD (Standard Deviation)
• Zone B – Between one SD and 2SD
• Zone C – Between 2SD and 3 SD

Using the above zones calculation, I need to determine the below rules.
Rule 1 – One point below LCL
Rule 2 - Two out of three points in C zone or below