View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Karen
 
Posts: n/a
Default Replace Error with a Dash

I have a cell with the following formula:
{=AVERAGE(IF(B4:M4<0,B4:M4))}
It's producing the infamous #DIV/0! error - When the cell produces this
error, I just want a dash in its place. How can this be done?

Thank you