在excel中,E3为一个if公式,我想在I3中将E3作为一个条件,也写一个if函数,但是为什么不能应用E3的数值?如:E3=IF(D3>=13,"6",IF(D3>=7,"5",IF(D3>=4,"4",IF(D3>=3,"3",IF(D3>=2,"2",IF(D3>=1,"1",IF(D3>=0,"0")))))));F3=IF(D3>=
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/28 11:21:41
![在excel中,E3为一个if公式,我想在I3中将E3作为一个条件,也写一个if函数,但是为什么不能应用E3的数值?如:E3=IF(D3>=13,](/uploads/image/z/3977561-65-1.jpg?t=%E5%9C%A8excel%E4%B8%AD%2CE3%E4%B8%BA%E4%B8%80%E4%B8%AAif%E5%85%AC%E5%BC%8F%2C%E6%88%91%E6%83%B3%E5%9C%A8I3%E4%B8%AD%E5%B0%86E3%E4%BD%9C%E4%B8%BA%E4%B8%80%E4%B8%AA%E6%9D%A1%E4%BB%B6%2C%E4%B9%9F%E5%86%99%E4%B8%80%E4%B8%AAif%E5%87%BD%E6%95%B0%2C%E4%BD%86%E6%98%AF%E4%B8%BA%E4%BB%80%E4%B9%88%E4%B8%8D%E8%83%BD%E5%BA%94%E7%94%A8E3%E7%9A%84%E6%95%B0%E5%80%BC%3F%E5%A6%82%EF%BC%9AE3%3DIF%28D3%3E%3D13%2C%226%22%2CIF%28D3%3E%3D7%2C%225%22%2CIF%28D3%3E%3D4%2C%224%22%2CIF%28D3%3E%3D3%2C%223%22%2CIF%28D3%3E%3D2%2C%222%22%2CIF%28D3%3E%3D1%2C%221%22%2CIF%28D3%3E%3D0%2C%220%22%29%29%29%29%29%29%29%EF%BC%9BF3%3DIF%28D3%3E%3D)
在excel中,E3为一个if公式,我想在I3中将E3作为一个条件,也写一个if函数,但是为什么不能应用E3的数值?如:E3=IF(D3>=13,"6",IF(D3>=7,"5",IF(D3>=4,"4",IF(D3>=3,"3",IF(D3>=2,"2",IF(D3>=1,"1",IF(D3>=0,"0")))))));F3=IF(D3>=
在excel中,E3为一个if公式,我想在I3中将E3作为一个条件,也写一个if函数,但是为什么不能应用E3的数值?
如:E3=IF(D3>=13,"6",IF(D3>=7,"5",IF(D3>=4,"4",IF(D3>=3,"3",IF(D3>=2,"2",IF(D3>=1,"1",IF(D3>=0,"0")))))));
F3=IF(D3>=13,"30",IF(D3>=7,"25",IF(D3>=4,"20",IF(D3>=3,"15",IF(D3>=2,"10",IF(D3>=1,"5",IF(D3>=0,"0")))))));
我想要I3=IF((D3>=1)*(K3>0)*(K3>=E3)*(L3>=F3),"1","0"),但是不管怎么设置,I3 的结果都为0.这是怎么回事,我如何才能应用到E3,F3的数值呢?
在excel中,E3为一个if公式,我想在I3中将E3作为一个条件,也写一个if函数,但是为什么不能应用E3的数值?如:E3=IF(D3>=13,"6",IF(D3>=7,"5",IF(D3>=4,"4",IF(D3>=3,"3",IF(D3>=2,"2",IF(D3>=1,"1",IF(D3>=0,"0")))))));F3=IF(D3>=
因为你的判断条件类似于“D3>=1”,其中“1”是数值格式,而上面公式返回结果是带引号的“"30"”,属于文本格式,文本数字不等于数值.
将公式中所有的数字中的引号“""”去掉,就可以了.如:
F3=IF(D3>=13,30,IF(D3>=7,25,IF(D3>=4,20,IF(D3>=3,15,IF(D3>=2,10,IF(D3>=1,5,IF(D3>=0,0)))))))