I have a column of formulas that is basically total cost of product/number of uses=cost per use. When none of the specific product is being used, I get a #DIV/0! error. I know what this is telling me, but I am looking for a way to hide it, just to make my spreadsheet look tidier to customers while we are in the process of manipulating numbers.
Does any one know how to do this?
Thanks
Bookmarks