From: Dharmesh on


"Bruce Sinclair" wrote:

> In article <207F7DC3-DFD2-4355-B9E1-375B827BCE0C(a)microsoft.com>, =?Utf-8?B?TGVsYW5kNw==?= <Leland7(a)discussions.microsoft.com> wrote:
> >Fortunately, I'm not going to have any decimal point digits ... so for my
> >needs, this will work !!! THANKS A BUNCH !
>
> It may well give you the answer you want ... just be aware that it is still
> wrong. There are good reasons why dividing by zero makes no sense and should
> be an error.
> Hiding the resulting error is another question :)
>
> >"JE McGimpsey" wrote:
> >
> >> This would give you the result you want:
> >>
> >> C1 =IF(B1=0, A1, A1/B1-1)
> >>
> >> formatted as a percentage, but that makes zero sense mathematically.
> >>
> >> For instance
> >>
> >> A B C
> >> 1 4 0.00 400%
> >> 2 4 0.01 39900%
> >> 3 4 0.80 400%
> >>
> >> So your resulting "increase" would be 400% if you started at 0 or 0.80.
> >> How would you tell the difference?
> >>
> >>
> >>
> >>
> >>
> >> In article <C3838062-4C69-4C18-86C7-87B8463D9301(a)microsoft.com>,
> >> Leland7 <Leland7(a)discussions.microsoft.com> wrote:
> >>
> >> > I am doing comparison figures to determine percent of change. Some figures
> >
> >> > compare for example 4 to 0 and instead of getting an increase of 400%, get
> >> > #DIV/0! .... anyone know a formula that would give me the right percent?
> >>
>
> Bruce
>
> ----------------------------------------
> I believe you find life such a problem because you think there are the good
> people and the bad people. You're wrong, of course. There are, always and
> only, the bad people, but some of them are on opposite sides.
>
> Lord Vetinari in Guards ! Guards ! - Terry Pratchett
>
> Caution ===== followups may have been changed to relevant groups
> (if there were any)
>
>