code gives an error

[********Meg]

i am doing some tabulations in excel 2003 and because in some rows there is
no data, i get an error or Dvd! message
is there anyway to code the system to leave those blank?

 

[Dave Peterson]

If your formula looks like:

=a1/b1
You can use:
=if(b1=0,"",a1/b1)