On 2002-03-28 08:34, Matt wrote:
It's probably wishful thinking but I'm sure I've used it before - is there a custom format which I can apply to a cell to hide the #DIV/0 error?
thanks Matt
On 2002-04-01 04:13, Geronimo wrote:
Here is an example of some formatting that I'm using currently:
=IF(ISBLANK(B32)," ",AVERAGE(B32:E32))
It does away with the #DIV/0 error text. Of course, replace my cell & range references with your own.
This message was edited by Geronimo on 2002-04-01 04:14