Thread
:
Replace Error with a Dash
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Karen
Posts: n/a
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
Reply With Quote