Forum Discussion
Solved
#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...
You can replace IFERROR with OMFEL in your formula. The correct version is then:
=OMFEL(AVRUNDA(MEDEL(G4:G22);2);"")
Hope that helps
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)