#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...
 

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

#DIV/O! 2
How to use AVERAGEIFS for a date range 2
#div/0 error 2
If cell is blank automatically enter today's date in the same cell 21
sumif function with multiple sheets 8
Adding a column and recalculate formula automatically 4
#div/0 ? 6
Formula function for ignoring cells/results equal to 0 (zero) ? 1

Top