Remove error notification X7/M7=0 when one or both cell values are
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
|