If the dividend and the divisor are in cells A1 and B1:
=IF(B1=0,"N/A",A1/B1)
--
Vasant
"jacob" wrote in message
...
A lot of the data i deal with involves counting and dividing. A percentage
may be presented in the worksheet. Instead of #DIV/0!, I would like for
N/A,
not available, to appear in the cell. How do i create a formula of sorts
that
will display the average, for example, or N/A if there is division by 0.
This will help me a lot because i won't have to look over hundreds of
cells
to spot all the divison by zero errors and i don't have to worry about
recalculations not appearing because formulas have been deleted to put N/A
in
the cells
Thanks very much!
|