Forum Discussion
thob02
Apr 14, 2026Occasional Reader
#DIVISION/0!
Hi. I have a problem (this is in Swedish) where I get #DIVISION/0! in a field in excel. The formula in the field is =AVRUNDA(MEDEL(G4:G22);2) Translated I think it is =ROUND(AVERAGE(G4:G22);2) I h...
m_tarler
Apr 14, 2026Silver Contributor
I suspect the problem is
a) is IFERROR the correct command in Swedish
b) you used a comma instead of a semi-colon, which is what I assume it needs since that is what was used for the ROUND( ... ; 2)