the first If condition checks if the number is greater than 0. If it is, a message box displays "The number is positive." If not, the ElseIf statement checks if the number is less than 0. If it is, a message box displays "The number is negative." If neither of these conditions are met, the Else statement executes and a message box displays "The number is zero."
To create an inline IF statement (akin to the tertiary operator "? :" we're all used to)
You must follow this syntax
to remember it, IIF stands for "INLINE IF"
ElseIf statement allows you to test additional conditions if the first If condition and any subsequent ElseIf conditions are not met. The syntax for the ElseIf statement is as follows: