Forum Discussion

thob02's avatar
thob02
Occasional Reader
Apr 14, 2026

#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 have tried to do as you described with =IFERROR(AVRUNDA(MEDEL(G4:G22);2),"") But I get an error message. 

 

excel
Formulas and Functions

2 Replies

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Apr 14, 2026

    You can replace IFERROR with OMFEL in your formula. The correct version is then:

    =OMFEL(AVRUNDA(MEDEL(G4:G22);2);"")

    Hope that helps

  • m_tarler's avatar
    m_tarler
    Silver Contributor
    Apr 14, 2026

    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)