=IF(OR(E9=0,H9=0),ROUNDUP((E9-G9)/H9,
来源:学生作业帮助网 编辑:六六作业网 时间:2024/12/22 10:54:11
=IF(OR(E9=0,H9=0),ROUNDUP((E9-G9)/H9,=IF(OR(E9=0,H9=0),ROUNDUP((E9-G9)/H9,=IF(OR(E9=0,H9=0),ROUNDUP(
=IF(OR(E9=0,H9=0),ROUNDUP((E9-G9)/H9,
=IF(OR(E9=0,H9=0),ROUNDUP((E9-G9)/H9,
=IF(OR(E9=0,H9=0),ROUNDUP((E9-G9)/H9,
E9或H9任一单元格数值为0,公式所在单元格数值为0,否则,等于(E9-G9)/H9,0)的向上取整值.roundup的意思是向上取整,即1.2或1.8,取整后均为2