Small numbers are labeled as Zeros

P

Patricia

Please somebody help me.

I have a really small result of a rpobability that yields up t
0.00000000000000000000000195823212135.

This value is labeled as Zero in the cell and when I multiply it by an
other number it yields to Zero instead of some value multiply b
0.00000000000000000000000195823212135 that should not yield zero.

Please help me,

Thanks,

Patrici
 
F

Frank Kabel

Hi
Excel only supports 15 significant digit. you have exceeded this limit
with your value
 
J

Jerry W. Lewis

Excel's limit is 15 significant digits, not 15 decimal places.

0.00000000000000000000000195823212135
is only 12 significant digits.

If Patricia entered 0.00000000000000000000000195823212135 into a cell,
it would be stored properly, and would produce nonzero results when
multiplied by another nonzero value in excess of 2E-284 in magnitude.
The exception would be if the original cell was formatted to display
zero and "Precision as Displayed" was checked at Tools|Opsions|Calculation.

If the value of 0.00000000000000000000000195823212135 is obtained by
subtraction
=a-b
and if ROUND(a,15)=ROUND(b,15), then the OP could try changing the
formula to
=(a-b)
Since the binary representation of numbers used by almost all software
(including Excel) can only reliably resolve 15 decimal digits, Excel
will arbitrarily zero final subractions if the two numbers are equal to
15 decimal digits. Placing parentheses around the equation means that
the subtraction is no longer viewed as the last operation, so Excel will
not aribrarily zero the result.

If neither of thes guesses is right, then Patricia will need to provide
more information.

Jerry
 
G

Giedrius

What i did is:

First of all lets do formating cells. Choose digits number as high a
possible and you'll see the result that you want to have. Then multipl
and repeat the formating for the result cell. Thats all.
Everything looks fine at my workbook. :))

Giedriu
 
Top