View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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