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/10/04 06:03:20
if语句excelif语句是=IF(OR(AB3=
xS]kP+#@wL!xc@snk\*WmrNY+vH39'ez7n!y9)wαnn|ZzWz%^L\īAe/I?܎ @P,ő3,13*7xXA'Ida KcH c50ιg8_3BrsQ wZ#;ZEG66ahPn~ k_ l<,M˚穄s~ĔfD6wgfsGcޥ xuL-eyaI1+ R2k6'ֲeɐ4ٲ EVA4[dm޴t!iK"#з\l:AH^XESdLeE18bh٬͝ pR2Wf N϶8t}Ԩ U q{(N/,ѥ`g7tO~tR ?R wLװH/E Q |<|Աh 7*Aj ر

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)会出错,字符不能运算,清空其中一个看看.
别的没怎么细看,不知道还有没有错误.