Getting false divide by zero in Excel
up vote
0
down vote
favorite
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?
excel statistics
asked yesterday
Mate Mrše
459214
add a comment |
up vote
0
down vote
favorite
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?
excel statistics
asked yesterday
Mate Mrše
459214
are you sure that you have the range correctly selected? The only case how I can reproduce #Div/0! is if I select only one cell for STDEV (as it divides by N-1 it would make sense to show this kind of error in such case). Also - sometimes even if the value is formatted as number it is still considered a text for functions. Try re-entering some of the values.
– Pavel_V
yesterday
Could you please share some data.. according to your description it should work.
– Wizhi
yesterday
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
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?
excel statistics
asked yesterday
Mate Mrše
459214
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?
excel statistics
excel statistics
asked yesterday
Mate Mrše
459214
asked yesterday
Mate Mrše
459214
asked yesterday
Mate Mrše
459214
asked yesterday
Mate Mrše
459214
asked yesterday
Mate Mrše
459214
459214
are you sure that you have the range correctly selected? The only case how I can reproduce #Div/0! is if I select only one cell for STDEV (as it divides by N-1 it would make sense to show this kind of error in such case). Also - sometimes even if the value is formatted as number it is still considered a text for functions. Try re-entering some of the values.
– Pavel_V
yesterday
Could you please share some data.. according to your description it should work.
– Wizhi
yesterday
add a comment |
are you sure that you have the range correctly selected? The only case how I can reproduce #Div/0! is if I select only one cell for STDEV (as it divides by N-1 it would make sense to show this kind of error in such case). Also - sometimes even if the value is formatted as number it is still considered a text for functions. Try re-entering some of the values.
– Pavel_V
yesterday
Could you please share some data.. according to your description it should work.
– Wizhi
yesterday
are you sure that you have the range correctly selected? The only case how I can reproduce #Div/0! is if I select only one cell for STDEV (as it divides by N-1 it would make sense to show this kind of error in such case). Also - sometimes even if the value is formatted as number it is still considered a text for functions. Try re-entering some of the values.
– Pavel_V
yesterday
are you sure that you have the range correctly selected? The only case how I can reproduce #Div/0! is if I select only one cell for STDEV (as it divides by N-1 it would make sense to show this kind of error in such case). Also - sometimes even if the value is formatted as number it is still considered a text for functions. Try re-entering some of the values.
– Pavel_V
yesterday
Could you please share some data.. according to your description it should work.
– Wizhi
yesterday
Could you please share some data.. according to your description it should work.
– Wizhi
yesterday
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
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.
answered yesterday
Mate Mrše
459214
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
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.
answered yesterday
Mate Mrše
459214
add a comment |
up vote
0
down vote
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.
answered yesterday
Mate Mrše
459214
add a comment |
up vote
0
down vote
up vote
0
down vote
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.
answered yesterday
Mate Mrše
459214
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.
answered yesterday
Mate Mrše
459214
answered yesterday
Mate Mrše
459214
answered yesterday
Mate Mrše
459214
answered yesterday
Mate Mrše
459214
459214
add a comment |
add a comment |
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53203676%2fgetting-false-divide-by-zero-in-excel%23new-answer', 'question_page');
}
);
Post as a guest
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
are you sure that you have the range correctly selected? The only case how I can reproduce #Div/0! is if I select only one cell for STDEV (as it divides by N-1 it would make sense to show this kind of error in such case). Also - sometimes even if the value is formatted as number it is still considered a text for functions. Try re-entering some of the values.
– Pavel_V
yesterday
Could you please share some data.. according to your description it should work.
– Wizhi
yesterday