=if(m13=0,"",m10/m13)
Jerie wrote:
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
--
Dave Peterson
|