END.IF

Macro Sheets Only

Ends a block of functions associated with the preceding IF function. You must include one and only one END.IF function for each macro-sheets-only syntax form (syntax 2) of the IF function in a macro. Syntax 1 of the IF function, which can be used on both worksheets and macro sheets, does not require an END.IF function. Use END.IF with IF, ELSE, and ELSE.IF when you want to perform multiple actions based on a condition. This method is preferable to using GOTO because it makes your macros more structured.

Syntax

END.IF( )

Remarks

Related Functions

ELSE Specifies an action to take if an IF function returns FALSE

ELSE.IF Specifies an action to take if an IF or another ELSE.IF function returns FALSE

IF Specifies an action to take if a logical test is TRUE

List of Control Functions