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

Excel does not accept text format! 0
divide by 0 error jmp 2
A useful AVERAGE calculation without using the built-in AVERAGE function 3
#DIV error 5
Divide two cells and if the number is negative display is as zero 2
What Am I Doing Wrong Re Some Simple Math On A Column ? 2
formula for spreadsheet, avoiding zeros? 5
Number entries are automatically divided by 100 - Excel 2003 1

Top