Thread: Hide #DIV/0!
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sam Garcia Sam Garcia is offline
external usenet poster
  
Posts: 1
Default Hide #DIV/0!
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.
Reply With QuoteReply With Quote