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...
NikolinoDE
Apr 14, 2026Platinum Contributor
You can replace IFERROR with OMFEL in your formula. The correct version is then:
=OMFEL(AVRUNDA(MEDEL(G4:G22);2);"")
Hope that helps