The divide by zero error will only happen when B1 equals zero, so just test
for that condition. Unfortunately, you didn't say what you want to happen
for this condition, so I'll just show ??? in the cell (change that to
whatever you want)...

IF(B1=0,"???",A1/B1)

--
Rick (MVP - Excel)


"Meebers" wrote in message
...
If in cell c1 I have a formula =a1/b1 and either one or both are empty,
how do I check for that so as not to produce a divide by 0.