I understand what you are trying to say, but technically there is no "Then Else" involved with an Excel IF function. There are only "value_if_true" and "value_if_false" arguments.
IF(logical_test, value_if_true, [value_if_false])
I only bring this up because VBA does indeed allow for If-Then-Else constructs - using those exact terms - but an Excel IF function does not. Yes, the value_if_true could be considered equivalent to the "Then" and the value_if_false could be considered equivalent to the "Else", but those terms will not appear in any Help files associated with the IF function.
Admittedly, I may be picking a nit here, but I am simply trying to avoid any confusion for a member who may be unfamiliar with the IF function.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.