单元格输入公式问题

hahazeng

大家好，我想用VB在单元格输入=sumif（zi:zj, "T "wi:zj)*(1-Sheet03.Cells(11, 7))*IF(Sheet8.Cells(k + 1, 26) = "K"，1.1,1)语句如下：
其中i、j、k是变量


语句：Sheet8.Cells(k + 4, 23).Formula = "= SUMIF（Z" & i & ":Z" & j & "," & """T""" & "," & "W" & i & ":W" & j & ")*(1-" & Sheet03.Cells(11, 7) * 100 & "%)*if（" & Sheet8.Cells(k + 1, 26) = "K" & ",1,1.1)"

结果不正确，结果是个“flase”
    如果Sheet8.Cells(k + 4, 23).Formula = "= SUMIF（Z" & i& ":Z" & j & "," & """T""" & "," & "W" & i & ":W" & j & ")*(1-" & Sheet03.Cells(11, 7) * 100 & "%)”
   结果=sumif（zi:zj, "T "wi:zj)*(1-Sheet03.Cells(11, 7))，结果正确


请问如何把“*IF(Sheet8.Cells(k + 1, 26) = "K"，1.1,1)”添加到语句中？

microyip

把你的i、j、k前后也用&连起来

hahazeng

不好意思，没有明白

hahazeng

microyip 发表于 2018-8-2 16:11
把你的i、j、k前后也用&连起来

不好意思，没有明白，语句改为：Sheet8.Cells(k + 4, 23).Formula = "= SUMIF（Z" & i & ":Z" &j & "," & """T""" & "," & "W" & i & ":W" & j & ")*(1-" & Sheet03.Cells(11, 7) * 100 & "%)*if（" & Sheet8.Cells(k + 1, 26) & "= ""扩容"" " & ",1,1.1)"
结果最后那个if语句每次要求打开sheet8，结果是” Sheet8.Cells(k + 1, 26)“显示不正确

hahazeng

hahazeng 发表于 2018-8-2 16:37
不好意思，没有明白，语句改为：Sheet8.Cells(k + 4, 23).Formula = "= SUMIF（Z" & i & ":Z" &j & "," & ...

自己顶了一下

microyip

hahazeng 发表于 2018-8-2 21:08
自己顶了一下

你把附件附上，把正确的公式模拟出来，当然这个过程其实录制一下宏，就差不多得到结果了