I have a few sensor readings and I'm checking to see if the values are in the acceptable range.
To do this I use an IF
to check if the values are >
or <
the calculated (average) value. The results are stored in the respective columns. Finally I sum the results to get the count of how many are out of bounds (i.e. above the average).
For example, Ax
is compared with Mean
.Ax
to get either 1
or 0
in If value is outside accepted bounds
.Ax
:
Then the sum of If value is outside accepted bounds
.Ax
is performed to get Number of values outside bound
.Ax
:
Question
How do I convert this into a single formula?