I want to have average for some float type cells and I don't have any empty cells. But when I use average formula it shows a div/0 error. I have changed the format of cells to number but it does not work.
screen shot :
average cell format :
Asked
Active
Viewed 3,106 times
-2
Hasta Dhana
- 4,699
- 7
- 17
- 26
shima homayouni
- 1
- 1
- 2
-
1Please show what you have done, probably a screenshot in this case. – Tatsuyuki Ishi Mar 12 '17 at 10:40
-
there is an screenshot attached – shima homayouni Mar 12 '17 at 11:08
-
Please also clarify the full expression you're using in the average cell. – Tatsuyuki Ishi Mar 12 '17 at 11:10
-
there is an other screenshot – shima homayouni Mar 12 '17 at 11:19
2 Answers
0
For your system / numbers is a "." the decimal separator or ","? This could be causing your error.
Solar Mike
- 7,156
- 4
- 17
- 32
-
I changed the decimal separator to "." but it does not changed. – shima homayouni Mar 12 '17 at 12:07
-
Have you tried using SUM() or MAX() on the same range of numbers? i only ask as if they are not accepted as numbers then the functions won't work - I entered your numbers onto a sheet of mine and the average works so there must be something wrong... – Solar Mike Mar 12 '17 at 16:53
0
Finally I found it. With right clicking on the error and selecting "convert to number" the format will be changed and so the average result will be shown
shima homayouni
- 1
- 1
- 2