IF 判断语句

1、最规范的判断语句

1. If score ＞= 60 Then
   
2.     Cells(8,6) = “及格‘
   
3. Else
   
4.     Cells(8,6) = "不及格"
   
5. End If

复制代码

2、Elseif语句

1. If score ＞= 85 Then
   
2.     Cells(8,6) = “A‘
   
3. Elseif score ＞= 75 Then
   
4.     Cells(8,6) = "B"
   
5. Elseif score ＞= 60 Then
   
6.     Cells(8,6) = "C"
   
7. Else
   
8.     Cells(8,6) = "D"
   
9. End If

复制代码