|
楼主 |
发表于 2013-3-13 15:58
|
显示全部楼层
兰色幻想 发表于 2013-3-13 15:50
.Cells(MR, 11).Formula = "=IF(E" & MR & "-D" & MR & "> 0,E" & MR & "-D" & MR & ","""")"
.Cells(Mr, 11).Formula = "=IF(E" & Mr & "-D" & Mr & "> 0,E" & Mr & "-D" & Mr & ","""")"
.Cells(Mr, 11).Formula = "=IF(E" & Mr & "-D" & Mr & "> 0,E" & Mr & "-D" & Mr & ","")"
在单元格里=IF(E2-D2>0,E2-D2,"")只需要2个",在代码里怎么需要4个" |
|