Getting #DIV/0!, how to get 0%?

External Since: Mar 31, 2006 Posts: 23

I am still getting a Value after changing formula to instead of #DIV/0!
=IF(c13=0,0,(c12:c16)/c13

"Peo Sjoblom" wrote:

> =IF(E34=0,0,(E34-D34)/E34)
>
> --
>
>
> Regards,
>
>
> Peo Sjoblom
>
>
>
> "pgarcia" <pgarcia.TakeThisOut@discussions.microsoft.com> wrote in message
> news:F777B88C-63AF-4202-8F40-6218195C2EE1@microsoft.com...
> > I'm getting #DIV/0! with the following formula, the cell is format as a
> > percent. Thanks
> >
> > =(E34-D34)/E34
> > E34 = 0
> > D34 = 0
> > Result should be 0%
>
>
>

External Since: May 20, 2009 Posts: 16

You are using a range divided by a number and you should change that to a
single cell

=IF(C13=0,0,C12/C13)

or something

and the only way you can get a value error is if C13 itself has a DIV error
in it.

Maybe you should explain what you are trying to do instead?

--

Regards,

Peo Sjoblom

"kevin" <kevin DeleteThis @discussions.microsoft.com> wrote in message
news:45F01960-E162-4151-9731-318C977C8C6F@microsoft.com...
>I am still getting a Value after changing formula to instead of #DIV/0!
> =IF(c13=0,0,(c12:c16)/c13
>
> "Peo Sjoblom" wrote:
>
>> =IF(E34=0,0,(E34-D34)/E34)
>>
>> --
>>
>>
>> Regards,
>>
>>
>> Peo Sjoblom
>>
>>
>>
>> "pgarcia" <pgarcia DeleteThis @discussions.microsoft.com> wrote in message
>> news:F777B88C-63AF-4202-8F40-6218195C2EE1@microsoft.com...
>> > I'm getting #DIV/0! with the following formula, the cell is format as a
>> > percent. Thanks
>> >
>> > =(E34-D34)/E34
>> > E34 = 0
>> > D34 = 0
>> > Result should be 0%
>>
>>
>>