Whoops! My second formula tested for M7 being empty, but not for it being
equal to zero.

=IF(COUNT(X7,M7)=2,IF(M7=0,"",X7/M7),"")

or
IF(OR(M7=0,X7=""),"",X7/M7)
--
David Biddulph


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
=IF(M7=0,"",X7/M7)
If X7 is zero that doesn't give an error, but if you want to trap for that
too, try =IF(COUNT(X7,M7)=2,X7/M7,"")
--
David Biddulph


"chipmac1" wrote in message
...

How to remove error notification when X7/M7=0 when one or both cell
values
are 0