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

Because you can't divide by zero, that is what the error says as well


--
Regards,

Peo Sjoblom


"sony654" <[email protected]> wrote in message
news:[email protected]...
> if "a2/b2" = .17/0 = 100%, why can't I get in a formula, instead of
> #DIV/0!?
> Thanks - Tom
> --
> Sony Luvy

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" <[email protected]> wrote in message
news:[email protected]...
> if "a2/b2" = .17/0 = 100%, why can't I get in a formula,
> instead of #DIV/0!?
> Thanks - Tom
> --
> Sony Luvy

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" <[email protected]> wrote in message
> news:[email protected]...
> > if "a2/b2" = .17/0 = 100%, why can't I get in a formula,
> > instead of #DIV/0!?
> > Thanks - Tom
> > --
> > Sony Luvy
>
>
>

Look at the ABS function

--
Regards,

Peo Sjoblom


"sony654" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> > if "a2/b2" = .17/0 = 100%, why can't I get in a formula,
>> > instead of #DIV/0!?
>> > Thanks - Tom
>> > --
>> > Sony Luvy
>>
>>
>>