Forum Discussion

Susie_P's avatar
Susie_P
Copper Contributor
Aug 24, 2023
Solved

Removing or hiding errors

Hi there,   Can anyone help please as this is driving me nuts! If so, could you take a look at the screenshots below - I have included the formulas for you to see.   I am creating a document for ...
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Aug 24, 2023

    Susie_P 

    To exclude errors you may use something like

     

    =AVERAGEIFS(S8:Y8, S8:Y8, "<>#DIV/0!")

     

    Average in any case returns number. If nothing except errors then zero. To have empty string you may wrap it as

     

    =IF( AVERAGEIFS(S8:Y8, S8:Y8, "<>#DIV/0!"), AVERAGEIFS(S8:Y8, S8:Y8, "<>#DIV/0!"), "" )

     

Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Aug 24, 2023

OliverScheurich 

Or simply:

=IFS(Z8="","",Z8>=3.5,AA$3,Z8>=2.5,AA$4,Z8>=1.5,AA$5,Z8>=0,AA$6)
Susie_P's avatar
Susie_P
Copper Contributor
Aug 24, 2023
Thank you for taking the time to reply - it's fixed!

Resources