Forum Discussion

TihomirSano's avatar
TihomirSano
Copper Contributor
Sep 15, 2022
Solved

wrong mulitplying

Could someone try to multiply in excel all odd numbers from 1 to 99.

1*3*5*7*9*....*97*99

 

The result should have the last digit 5, but excel say it is 0.

This is wrong.

 

  • Excel has limited number of digits of precision. The answer appears to be 2.73E+78 so excel can't keep 79 digits of precision so yeah, it rounds off/ truncates the value.
  • mtarler's avatar
    mtarler
    Silver Contributor
    Excel has limited number of digits of precision. The answer appears to be 2.73E+78 so excel can't keep 79 digits of precision so yeah, it rounds off/ truncates the value.

Resources