1. Forum
  2. Usenet
  3. MICROSOFT.PUBLIC.EXCEL.MI

  • Hide #DIV/0!

    From Sam Garcia@21:1/5 to All on Thu Mar 18 19:00:10 2021
    I have averageifs formula, i want to hide the #DIV/0! what should i do?
    I tried iferror(averageifs...,"") but won't work.
    Thank you.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)