Hi! I’m a Mac user and an Excel beginner. I’ve done a lot of research into why the #DIV/0! comes up after selecting the numbers I need to find the standard deviation for yet found no solution. I had to do the averages manually because this problem also came up then. I’ve made sure it’s set to ‘number’, not ‘text’, and don’t know what else to do.

​Hi! I’m a Mac user and an Excel beginner. I’ve done a lot of research into why the #DIV/0! comes up after selecting the numbers I need to find the standard deviation for yet found no solution. I had to do the averages manually because this problem also came up then. I’ve made sure it’s set to ‘number’, not ‘text’, and don’t know what else to do.  Read More

​