#DIV/0!

J

Jerie

I have a formula as follows, m10/m13, cell m10 is
formated to " general " and cell M13 is formated to
" currency ".When those cells are 0 and $0.00 respectively
the formula returns #DIV/0! Is there a way to have blank
cells instead?

thank you all Jerie
 
D

Dave Peterson

=if(m13=0,"",m10/m13)


I have a formula as follows, m10/m13, cell m10 is
formated to " general " and cell M13 is formated to
" currency ".When those cells are 0 and $0.00 respectively
the formula returns #DIV/0! Is there a way to have blank
cells instead?

thank you all Jerie
Click to expand...
 
Top