Thread: #DIV/0!
View Single Post
  #1   Report Post  
Jerie
 
Posts: n/a
Default #DIV/0!

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