ExcelBanter - divide so no error Excel 2007

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - divide so no error Excel 2007 (https://www.excelbanter.com/new-users-excel/210346-divide-so-no-error-excel-2007-a.html)

Striker

divide so no error Excel 2007

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?

Peo Sjoblom[_2_]

divide so no error Excel 2007

=IF(B2=0,0,A2/B2)

--

Regards,

Peo Sjoblom

"Striker" wrote in message
...
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?

All times are GMT +1. The time now is 11:20 PM.