If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Remove error notification X7/M7=0 when one or both cell values are
How to remove error notification when X7/M7=0 when one or both cell values
are 0 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Remove error notification X7/M7=0 when one or both cell values are
=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 |
#4
|
|||
|
|||
Remove error notification X7/M7=0 when one or both cell values are
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 |
Thread Tools | |
Display Modes | |
|
|