divide so no error Excel 2007

S

Striker

I have a simple issue. I have two cells with numbers and I want to divide
one by the other and set it up on many cells. Problem is if I enter the
folmula befor there are actually numbers in the two cells I get the Divide
by 0 error (#DIV/0!)

So How can I divide A2 / B2 only if it won't produce an error?
 

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

divide by 0 error jmp 2
automate cell to divide by 1000 3
Formula help 3
division formula 2
Excel IF function in excel 2
#DIV/0! Error 1
divide by zero error 5
Need Help 1

Top