SUM函数减去SUMIF函数(或者SUM函数)的值用IF函数来判断对错的问题?A列 B列1\x057.41\x057.12\x05312.482\x052804.9公式为IF(SUM(B1:B2)=SUM(B1:B4)-SUMIF(A1:A4,"2",B1:B4),"TRUE","FALSE"),或者IF(SUM(B1:B2)=SUM(B1:B4)-SUM(B3:B4),"TR
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/29 22:08:37
![SUM函数减去SUMIF函数(或者SUM函数)的值用IF函数来判断对错的问题?A列 B列1\x057.41\x057.12\x05312.482\x052804.9公式为IF(SUM(B1:B2)=SUM(B1:B4)-SUMIF(A1:A4,](/uploads/image/z/6844153-49-3.jpg?t=SUM%E5%87%BD%E6%95%B0%E5%87%8F%E5%8E%BBSUMIF%E5%87%BD%E6%95%B0%28%E6%88%96%E8%80%85SUM%E5%87%BD%E6%95%B0%29%E7%9A%84%E5%80%BC%E7%94%A8IF%E5%87%BD%E6%95%B0%E6%9D%A5%E5%88%A4%E6%96%AD%E5%AF%B9%E9%94%99%E7%9A%84%E9%97%AE%E9%A2%98%3FA%E5%88%97+B%E5%88%971%5Cx057.41%5Cx057.12%5Cx05312.482%5Cx052804.9%E5%85%AC%E5%BC%8F%E4%B8%BAIF%28SUM%28B1%3AB2%29%3DSUM%28B1%3AB4%29-SUMIF%28A1%3AA4%2C%222%22%2CB1%3AB4%29%2C%22TRUE%22%2C%22FALSE%22%29%2C%E6%88%96%E8%80%85IF%28SUM%28B1%3AB2%29%3DSUM%28B1%3AB4%29-SUM%28B3%3AB4%29%2C%22TR)
SUM函数减去SUMIF函数(或者SUM函数)的值用IF函数来判断对错的问题?A列 B列1\x057.41\x057.12\x05312.482\x052804.9公式为IF(SUM(B1:B2)=SUM(B1:B4)-SUMIF(A1:A4,"2",B1:B4),"TRUE","FALSE"),或者IF(SUM(B1:B2)=SUM(B1:B4)-SUM(B3:B4),"TR
SUM函数减去SUMIF函数(或者SUM函数)的值用IF函数来判断对错的问题?
A列 B列
1\x057.4
1\x057.1
2\x05312.48
2\x052804.9
公式为IF(SUM(B1:B2)=SUM(B1:B4)-SUMIF(A1:A4,"2",B1:B4),"TRUE","FALSE"),
或者IF(SUM(B1:B2)=SUM(B1:B4)-SUM(B3:B4),"TRUE","FALSE")
此时显示TRUE,显然正确,若将B1改为7.9,或者B2改为7.6,仍然如此.
但若将B1改为7.x(x≠4,9)或者B2改为7.y(y≠1,6),比如B1为7.5,或者B2为7.2,按上述公式却显示FALSE,按常理应该还是显示TRUE啊
求解是什么原因呢?SUM、SUMIF或IF函数的Bug?还是我Excel的问题(我是破解版的OFFICE 2010)?还是?
SUM函数减去SUMIF函数(或者SUM函数)的值用IF函数来判断对错的问题?A列 B列1\x057.41\x057.12\x05312.482\x052804.9公式为IF(SUM(B1:B2)=SUM(B1:B4)-SUMIF(A1:A4,"2",B1:B4),"TRUE","FALSE"),或者IF(SUM(B1:B2)=SUM(B1:B4)-SUM(B3:B4),"TR
经试验,在B1和B2相加尾数为0.5或整数时,B3和B4相加的和不超过16位时,系统判断正确,当B1和B2相加尾数不为0.5的倍数时,只要B3、B4的和超过1000,就会产生楼主所说情况,不超过1000的话,系统判断正确;估计是系统计算精确度的关系产生的偏差.