在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/12/25 22:17:05
在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)))))))