珍珠湾ART

标题: Microsoft Excel bug? [打印本页]

作者: Xiangdang    时间: 2010-5-7 21:42
标题: Microsoft Excel bug?

Anybody knows how to use MS Excell to calculate/represent an integer number > 16 digits.  For example, I was trying to calculate 3^32.  This is a number > 16 digits and with last digit being 1.  However, my Excel gives me 1,853,020,188,851,840.  And if you continue to go 3^33 ... and larger index, the last digits are all wrong.  I always has the impression that Excel is "double precesion" that mean it can handle 32 digits of a number.   Maybe this is a bug?  Thanks.
 
 
www.ddhw.com

 

作者: 花心石    时间: 2010-5-10 06:04
标题: Microsoft Excel 处理的数字为双精度数,其有效数字仅有32位(2进制)即2^32-1

  Microsoft Excel 处理的数字为双精度数,其有效数字仅有32位(2进制)即2^32-1





www.ddhw.org---



作者: Xiangdang    时间: 2010-5-10 08:00
标题: 回复:Microsoft Excel 处理的数字为双精度数,其有效数字仅有32位(2进制)即2^32

是10进位的32位数字, 还是2进位的? 你没有讲明白.  谢谢.www.ddhw.com
 
www.ddhw.com

 





欢迎光临 珍珠湾ART (http://zzwav.com/) Powered by Discuz! X3