Remove error notification X7/M7=0 when one or both cell values are

C

chipmac1

How to remove error notification when X7/M7=0 when one or both cell values
are 0
 
D

Dave Peterson

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Warning when in another cell after entering a formula. 2
If any 3 of 5 values are 0 then 0. 8
Remove Identical words 0
IF Statement 2
How do I make #DIV/0! error message go away? 2
Use TODAY() function as the criteria in a SUMIF formula 1
Format Cell 3
Unable to correct VBA code 9

Top