Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Divide by Zero Error | Excel Worksheet Functions | |||
divide by 0 error jmp | New Users to Excel | |||
Divide by zero error | Excel Discussion (Misc queries) | |||
Divide by zero error | Excel Discussion (Misc queries) | |||
excel divide by zero error | Excel Worksheet Functions |