珍珠湾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
作者: 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 |