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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks