if语句excelif语句是=IF(OR(AB3="",X3=""),"",IF(X3="/",ROUND(1,2)&":"&ROUND((V3/(P3/O3)),2)&":"&ROUND(P3/(P3/O3),2)&":"&ROUND((AB3)/(P3/O3),4),IF(AB3="/",ROUND(1,2)&":"&ROUND((V3/(P3/O3)),2)&":"&ROUND(P3/(P3/O3),2)&":"&ROUND(X3/(P3/O3),2),ROUND(1,
来源:学生作业帮助网 编辑:作业帮 时间:2024/08/30 06:38:47
if语句excelif语句是=IF(OR(AB3="",X3=""),"",IF(X3="/",ROUND(1,2)&":"&ROUND((V3/(P3/O3)),2)&":"&ROUND(P3/(P3/O3),2)&":"&ROUND((AB3)/(P3/O3),4),IF(AB3="/",ROUND(1,2)&":"&ROUND((V3/(P3/O3)),2)&":"&ROUND(P3/(P3/O3),2)&":"&ROUND(X3/(P3/O3),2),ROUND(1,
if语句excel
if语句是=IF(OR(AB3="",X3=""),"",IF(X3="/",ROUND(1,2)&":"&ROUND((V3/(P3/O3)),2)&":"&ROUND(P3/(P3/O3),2)&":"&ROUND((AB3)/(P3/O3),4),IF(AB3="/",ROUND(1,2)&":"&ROUND((V3/(P3/O3)),2)&":"&ROUND(P3/(P3/O3),2)&":"&ROUND(X3/(P3/O3),2),ROUND(1,2)&":"&ROUND((V3/(P3/O3)),2)&":"&ROUND(P3/(P3/O3),2))))
但是怎么会显示错误呢?如果我把水泥加到里面形成三个量怎么处理
if语句excelif语句是=IF(OR(AB3="",X3=""),"",IF(X3="/",ROUND(1,2)&":"&ROUND((V3/(P3/O3)),2)&":"&ROUND(P3/(P3/O3),2)&":"&ROUND((AB3)/(P3/O3),4),IF(AB3="/",ROUND(1,2)&":"&ROUND((V3/(P3/O3)),2)&":"&ROUND(P3/(P3/O3),2)&":"&ROUND(X3/(P3/O3),2),ROUND(1,
因为你的表中X3和AB3里都有/,所以(AB3)/(P3/O3)会出错,字符不能运算,清空其中一个看看.
别的没怎么细看,不知道还有没有错误.