Here is a list of If Statement for Visual Basic for Application.
If – Then –
If EmployeeName = “Michael Douglas” Then
EmployeeDesig = “CEO”
End If
If – Then –Else –
If EmployeeName = “Michael Douglas” Then
EmployeeDesig = “CEO”
Else
EmployeeDesig = “Associate”
End If
If – Then – ElseIf
If EmployeeName = “Michael Douglas” Then
EmployeeDesig = “CEO”
ElseIf EmployeeName = “Tina Wales” Then
EmployeeDesig = “CFO”
Else
EmployeeDesig = “Associate”
End If
