Prev: IS THERE A FORMULA TO CALCULATE THE DISTANCE BETWEEN DATES
Next: Complex AND OR Formula
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" <chipmac1(a)discussions.microsoft.com> 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" <groups [at] biddulph.org.uk> 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" <chipmac1(a)discussions.microsoft.com> 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
>
>

 | 
Pages: 1
Prev: IS THERE A FORMULA TO CALCULATE THE DISTANCE BETWEEN DATES
Next: Complex AND OR Formula