How to hide the #DIV/0! ?

[excelos]

Hello!

I have a formula that makes a division and in some cells it shows #DIV/0! because it tries to divide by zero.

That's fine, but I just want these cells to be filled with N/A (not applicable) or zero or a dash or something more pretty than #DIV/0!

Any idea?

 

[sandy666]

=IFERROR(your_formula,"")

 

[r1998]

Hello excelos
i have data in cells
a1 =4/2
a2 =1/0
a3 = 200/50
so change a1 to this

=IF(ISERROR(4/2),0,4/2)

and drag till a3