Improving Excel Stability
=IF(A1=0," ",B1/A1)
You may prefer to use "" rather than " ".
--
David Biddulph
"Ken" wrote in message
...
I have sets of data in both Columns A & B. Column C is Column B divided by
Column A. ie... C1=B1/A1. In some cases the data in Column A are equal to
zero. What formula do I use to have C=B/A except when the answer would
result
in " #DIV/0! " in which case I would like the cells to be clean as in " ".
I
assume this makes the worksheet more stable, correct?
--
Ken
|