EXCEL 函数调用 判断?
发布网友
发布时间：2022-05-15 15:34
共1个回答
热心网友
时间：2024-03-02 11:55
如有疑问，请关注私信我
'自定义公式-按ALT+11-点击插入-点击模块
Function 判断(a As String, b As String)
If InStr(b, "A") > 0 Or InStr(b, "W") > 0 Or InStr(b, "C") > 0 Then
判断 = "10%"
Else
If InStr(a, "北京") > 0 And InStr(a, "0") > 0 Then
判断 = "5%"
Else
If InStr(a, "上海") > 0 And InStr(a, "1") > 0 Then
判断 = "5%"
Else
判断 = "2%"
End If
End If
End If
End Function
