division formula
 

when i try to divide 100 by 0, its gives me error message #DIV/0!. This i
undersatnd is immpossible. But can i setup a formula if any number being
divided by zero the outcome should be zero or n/a.
Thanks

division formula
 

One way:

A1 = 100
A2 = 0 (or empty cell which evaluates to 0)

=IF(A2=0,0,A1/A2)

--
Biff
Microsoft Excel MVP


"Rohit" wrote in message
...
when i try to divide 100 by 0, its gives me error message #DIV/0!. This i
undersatnd is immpossible. But can i setup a formula if any number being
divided by zero the outcome should be zero or n/a.
Thanks

division formula
 

Rohit,
Yes, it is possible. In the Cell that has the result as "#DIV/0!"
Type:
"=IF(ISERROR(C1/D1),0,(C1/D1))"
where 0 is zero or substitue "n/a"
hth

"Rohit" wrote:

when i try to divide 100 by 0, its gives me error message #DIV/0!. This i
undersatnd is immpossible. But can i setup a formula if any number being
divided by zero the outcome should be zero or n/a.
Thanks