S
sony654
if "a2/b2" = .17/0 = 100%, why can't I get in a formula, instead of #DIV/0!?
Thanks - Tom
Thanks - Tom
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peo Sjoblom
Because you can't divide by zero, that is what the error says as well
C
Chip Pearson
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
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
S
sony654
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
use the "and" or "or" function to display 100% or -100% depending on the
value in A2?
Thanks for your help on this... Tom
P
Peo Sjoblom
Look at the ABS function