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