Using AND function to evaluate cells
 

I have a list of data points, from this list I created a histogram and
distribution curve. What I need to add is if the data points are within one
standard deviation of the mean I want "OK" and if the data falls outside of
one standard deviation of the mean "Review". Could someone please help with
the exact location of where to type the formula (in the AND function dialog
box or the actual cell), and how the formula should be wrote?

Using AND function to evaluate cells
 

Just an example:


Lets say we have data in A1 thru A10
In A11 put:
=AVERAGE(A1:A10)
In A12 put:
=STDEVA(A1:A10)
In B1 put:
=IF(ABS(A1-$A$11)<$A$12,"OK","review")
and copy down
--
Gary's Student


"murphyslaw18" wrote:

I have a list of data points, from this list I created a histogram and
distribution curve. What I need to add is if the data points are within one
standard deviation of the mean I want "OK" and if the data falls outside of
one standard deviation of the mean "Review". Could someone please help with
the exact location of where to type the formula (in the AND function dialog
box or the actual cell), and how the formula should be wrote?