Using AND function to evaluate cells

M

murphyslaw18

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?
 
G

Gary''s Student

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top