Can anyone explain under what circumstances a simple division formula, say:
=SUM(B29/H29) in Excel 2000 would yield 0 (zero) as a result, rather than
the actual quotient? When I multiply the cell values: =SUM(B29*H29) the
cell produces the correct number. Likewise, there is no problem with
addition or subtraction.

FWIW, I figured out the source of the problem. The cell was formatted to
zero decimal places and the quotient was less than one - the zero number was
actually correct. Kind of a dumb mistake, but on the other hand it's
reassuring to know that the program's claim that it can handle division is
correct.

Roger Fink wrote:
> Can anyone explain under what circumstances a simple division
> formula, say: =SUM(B29/H29) in Excel 2000 would yield 0 (zero) as a
> result, rather than the actual quotient? When I multiply the cell
> values: =SUM(B29*H29) the cell produces the correct number.
> Likewise, there is no problem with addition or subtraction.

<g> Don't you just hate when that happens?

But wouldn't that be a nice feature ... the ability to toggle formatting
on/off for the entire worksheet?

(Who knows ... maybe you can?)

In article <#l1eM#xVKHA.4284@TK2MSFTNGP06.phx.gbl>, Roger Fink wrote:
> FWIW, I figured out the source of the problem. The cell was formatted to
> zero decimal places and the quotient was less than one - the zero number was
> actually correct. Kind of a dumb mistake, but on the other hand it's
> reassuring to know that the program's claim that it can handle division is
> correct.
>
> Roger Fink wrote:
> > Can anyone explain under what circumstances a simple division
> > formula, say: =SUM(B29/H29) in Excel 2000 would yield 0 (zero) as a
> > result, rather than the actual quotient? When I multiply the cell
> > values: =SUM(B29*H29) the cell produces the correct number.
> > Likewise, there is no problem with addition or subtraction.

The one place where one of those language-mangling, semi-intelligible,
Microsoft popups would have been useful and they're out to lunch.....

Steve Rindsberg wrote:
> <g> Don't you just hate when that happens?
>
> But wouldn't that be a nice feature ... the ability to toggle
> formatting on/off for the entire worksheet?
>
> (Who knows ... maybe you can?)
>
> In article <#l1eM#xVKHA.4284@TK2MSFTNGP06.phx.gbl>, Roger Fink wrote:
>> FWIW, I figured out the source of the problem. The cell was
>> formatted to zero decimal places and the quotient was less than one
>> - the zero number was actually correct. Kind of a dumb mistake, but
>> on the other hand it's reassuring to know that the program's claim
>> that it can handle division is correct.
>>
>> Roger Fink wrote:
>>> Can anyone explain under what circumstances a simple division
>>> formula, say: =SUM(B29/H29) in Excel 2000 would yield 0 (zero) as a
>>> result, rather than the actual quotient? When I multiply the cell
>>> values: =SUM(B29*H29) the cell produces the correct number.
>>> Likewise, there is no problem with addition or subtraction.

In article <u#B8hr0VKHA.3720@TK2MSFTNGP02.phx.gbl>, Roger Fink wrote:
> The one place where one of those language-mangling, semi-intelligible,
> Microsoft popups would have been useful and they're out to lunch.....

Even better! If only it existed. Foo.