C chipmac1 Jun 5, 2010 #1 How to remove error notification when X7/M7=0 when one or both cell values are 0
D Dave Peterson Jun 5, 2010 #2 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)
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)
