|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
不知道这个是否符合要求
- Function IFS(ByVal Logical1 As Variant, ByVal TrueVal1 As Variant, Optional ByVal Logical2 As Variant, Optional ByVal TrueVal2 As Variant, _
- Optional ByVal Logical3 As Variant, Optional ByVal TrueVal3 As Variant, Optional ByVal Logical4 As Variant, Optional ByVal TrueVal4 As Variant, _
- Optional ByVal Logical5 As Variant, Optional ByVal TrueVal5 As Variant, Optional ByVal Logical6 As Variant, Optional ByVal TrueVal6 As Variant, _
- Optional ByVal Logical7 As Variant, Optional ByVal TrueVal7 As Variant, Optional ByVal Logical8 As Variant, Optional ByVal TrueVal8 As Variant, _
- Optional ByVal Logical9 As Variant, Optional ByVal TrueVal9 As Variant, Optional ByVal Logical10 As Variant, Optional ByVal TrueVal10 As Variant, Optional ByVal FalseVal As Variant) As Variant
- '暂定容纳10个条件
- 'IFS(条件1, 真值1 ,[条件2, 真值2 , …… 条件10, 真值10 ,] 假值)
- If Logical1 Then
- IFS = TrueVal1
- ElseIf IsMissing(TrueVal2) Then
- IFS = Logical2
- ElseIf Logical2 Then
- IFS = TrueVal2
- ElseIf IsMissing(TrueVal3) Then
- IFS = Logical3
- ElseIf Logical3 Then
- IFS = TrueVal3
- ElseIf IsMissing(TrueVal4) Then
- IFS = Logical4
- ElseIf Logical4 Then
- IFS = TrueVal4
- ElseIf IsMissing(TrueVal5) Then
- IFS = Logical5
- ElseIf Logical5 Then
- IFS = TrueVal5
- ElseIf IsMissing(TrueVal6) Then
- IFS = Logical6
- ElseIf Logical6 Then
- IFS = TrueVal6
- ElseIf IsMissing(TrueVal7) Then
- IFS = Logical7
- ElseIf Logical7 Then
- IFS = TrueVal7
- ElseIf IsMissing(TrueVal8) Then
- IFS = Logical8
- ElseIf Logical8 Then
- IFS = TrueVal8
- ElseIf IsMissing(TrueVal9) Then
- IFS = Logical9
- ElseIf Logical9 Then
- IFS = TrueVal9
- ElseIf Logical10 Then
- IFS = TrueVal10
- Else
- IFS = FalseVal
- End If
- End Function
复制代码 |
评分
-
5
查看全部评分
-
|