Home |
Search |
Today's Posts |
#1
|
|||
|
|||
divide by 0
if "a2/b2" = .17/0 = 100%, why can't I get in a formula, instead of #DIV/0!?
Thanks - Tom -- Sony Luvy |
#2
|
|||
|
|||
Because you can't divide by zero, that is what the error says as well
-- Regards, Peo Sjoblom "sony654" wrote in message ... if "a2/b2" = .17/0 = 100%, why can't I get in a formula, instead of #DIV/0!? Thanks - Tom -- Sony Luvy |
#3
|
|||
|
|||
Sony,
0.17/0 does NOT equal 100%. You can't divide a number by zero. Use a formula like =IF(B2=0,100%,A2/B2) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "sony654" wrote in message ... if "a2/b2" = .17/0 = 100%, why can't I get in a formula, instead of #DIV/0!? Thanks - Tom -- Sony Luvy |
#4
|
|||
|
|||
Now, what if cell A2 is negative (-), ie. -6, the outcome is -100%. How do I
use the "and" or "or" function to display 100% or -100% depending on the value in A2? Thanks for your help on this... Tom "Chip Pearson" wrote: Sony, 0.17/0 does NOT equal 100%. You can't divide a number by zero. Use a formula like =IF(B2=0,100%,A2/B2) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "sony654" wrote in message ... if "a2/b2" = .17/0 = 100%, why can't I get in a formula, instead of #DIV/0!? Thanks - Tom -- Sony Luvy |
#5
|
|||
|
|||
Look at the ABS function
-- Regards, Peo Sjoblom "sony654" wrote in message ... Now, what if cell A2 is negative (-), ie. -6, the outcome is -100%. How do I use the "and" or "or" function to display 100% or -100% depending on the value in A2? Thanks for your help on this... Tom "Chip Pearson" wrote: Sony, 0.17/0 does NOT equal 100%. You can't divide a number by zero. Use a formula like =IF(B2=0,100%,A2/B2) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "sony654" wrote in message ... if "a2/b2" = .17/0 = 100%, why can't I get in a formula, instead of #DIV/0!? Thanks - Tom -- Sony Luvy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I divide a number by another number when there is no divis. | New Users to Excel | |||
Divide one row over other row I dont wont to divide one number | Excel Discussion (Misc queries) | |||
Divide Ranks into two teams (mathematical guru challenge) | Excel Discussion (Misc queries) | |||
How do I divide, what would the formula look like? I forgot. Than. | Excel Worksheet Functions | |||
I need to know if there is a way to divide a cell | Excel Discussion (Misc queries) |