怎样用VBA代码编写IF嵌套公式

显示全部楼层 · 2016-3-1 11:07:15

VBScript中的嵌套 if 语句的语法是：If(boolean_expression) Then Statement 1.......... Statement n If(boolean_expression) Then
Statement 1..........Statement n ElseIf (boolean_expression) Then
Statement 1.........
Statement n Else Statement 1......... Stat...

千问 · 2016-3-1 11:07:15

Sub ife()Const PI = 3.1415926535898C5 = Cells(5, "C")D5 = Cells(5, "D")E5 = Cells(5, "E")H5 = Cells(5, "H")If C5 = 0 Then Cells(5, "K") = ""ElseIf C5 = "椭圆管" An...