#div/0!
Hi All
I have a spreadsheet that calculates an average per week per item. Column A has a "From Date", Column B is the "To Date", Column C is the income and Column D has a formula to calculate the average per week. When there are no dates in a particular row, the above appears. I don't want to delete the formula as there will be data entered. Can I stop #DIV/0! from appearing and just show an empty cell?
Many thanks.
|