Getting false divide by zero in Excel
I have a column of numbers.
When I try calculating the standard deviation in Excel by using
STDEV(A1:A97) I get a '#DIV/o!' notice. But there are no zeroes or false values in that range.
All the data is formatted as numbers with 3 decimal places.
What am I missing?
Figured it out.
The problem was some of the cells contained a carriage return after the number, so I guess Excel counted those as zero.
After using the
TRIM()function, I was able to calculate what I needed.