きむら(K)さんのところããã
MSN相談箱 小数点の誤差をなくすのは可能?[ExcelとPHP]
Excel, PHP ã¨ãã«ææ°çã¯ãæ´æ°ã®åå·®ç©ã«é¢ãã¦ã¯64bitæ´æ°ã§è¨ç®ããã¾ãã
ãããã£ã¦ãsigned 32bit -(2ã®31ä¹)ã(2ã®31ä¹-1) ãèæ ®ããå¿ è¦ãããã¾ããã
ãªã®ã§åç´ã«10000åãã¦è¨ç®ããã¨ããã¨åçãã¾ããã
æµ®åå°æ°ç¹è¨ç®ã®å ´åã¯ä¸¸ã誤差ãçºçãã¾ãã
Excelã®æ¹ã精度ãé«ããªãã¯ãã§ãã
ããã§è°è«ãã¦ãå§ã¾ããªãã®ã§ãã¾ãã¯ãã£ã¦ã¿ã¦ãã ããã
ã¸ã¼ãPHPã®æ´æ°ã£ã¦ãã¤ã®ã¾ã«ã64bitã ã£ãã®ãã¼ããããªå¾®å¦ãªãã®ãå®è£ ãããªãã¦PHPã£ã¦ããã¼ãªï¼æ£
ç®èã¯ãã¦ãããPHPã®æ´æ°ã¯æ®å¿µãªãã符å·ä»ãã®32bitæ´æ°ã§ãã32bitã®ç¯å²ãè¶ ããã¨åæã«64bitæµ®åå°æ°ç¹æ°ã«ãªãã¾ããåæã«å¤åé·æ´æ°ã«ãªãè¨èªã ã£ããããã£ããã§ããã©ãã
64bitã¢ã¼ããã¯ãã£ã§64bitãªã³ã³ãã¤ã©ã ã¨64bitæ´æ°ãªPHPãåºæ¥ä¸ãããã§ããããï¼ãããããã¾ããã