珍珠湾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.

作者: 花心石 时间: 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进位的？你没有讲明白. 谢谢.

欢迎光临珍珠湾ART (http://66.160.158.134/)