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

If m7 is different from 0, then if x7 is 0, it won't cause an error.
(assuming that both cells contain numbers).

=if(m7=0,"",x7/m7)

or if x7 or m7 could contain text
=if(iserror(x7/m7),"",x7/m7)



chipmac1 wrote:

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

--

Dave Peterson

=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

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