if else in one line

method 1:

CheckIt = IIf(TestMe > 1000, "Large", "Small")

method 2:

i = 1
If i = 1 Then x = 3 : y = 3 Else x = 7 : y = 7

Reference

If ...else statement (Visual Basic)