Get a deviation reading
 

I have a column of numbers that I can get the average of. I want to analyze
each row (after I get the average) and compare it to the average. If it is
+/- .0005 then I want to mark a column called Outside Spec with an x or 1 to
indicate which rows are outside the accepted reading range. How would I do
this?

John Wright

Get a deviation reading
 

I have numbers in K1:K10 and in L1 I have
=IF(ABS(K1-AVERAGE($K$1:$K$10))0.3,"x","")
This I copy down to H10. There are x's in the cells when the deviation is
+/- 0.3
You need 0.0005 in place of 0.3

If you have the average in a cell, say B5 then you could use
=IF(ABS(K1-$B$5)0.3,"x","")

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"john wright" wrote in message
...
I have a column of numbers that I can get the average of. I want to
analyze each row (after I get the average) and compare it to the average.
If it is +/- .0005 then I want to mark a column called Outside Spec with an
x or 1 to indicate which rows are outside the accepted reading range. How
would I do this?

John Wright