Sub If条件()
If Sheet1.Range(“B1”) >= 90 Then
Sheet1.Range(“B2”) = “优秀”
ElseIf Sheet1.Range(“B1”) >= 80 Then
Sheet1.Range(“B2”) = “良好”
ElseIf Sheet1.Range(“B1”) >= 79 Then
Sheet1.Range(“B2”) = “中等”
Else
Sheet1.Range(“B2”) = “较差”
End If
End Sub
VBA If语句举例
最新推荐文章于 2024-05-03 23:38:22 发布