From: chipmac1 on 5 Jun 2010 16:48 How to remove error notification when X7/M7=0 when one or both cell values are 0 From: Dave Peterson on 5 Jun 2010 17:39 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 From: "David Biddulph" groups [at] on 5 Jun 2010 17:44 =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 news:137187A4-FF9E-4117-A693-676601E28C3D(a)microsoft.com...> > How to remove error notification when X7/M7=0 when one or both cell values > are 0 From: "David Biddulph" groups [at] on 5 Jun 2010 17:47 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" wrote in message news:6LadnUsdhvK5WJfRnZ2dnUVZ8tednZ2d(a)bt.com...> =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 > news:137187A4-FF9E-4117-A693-676601E28C3D(a)microsoft.com... >> >> How to remove error notification when X7/M7=0 when one or both cell >> values >> are 0 > >  |