You can use If…ElseIf…ElseIf…ElseIf…Else to check more conditions:Įxample 1: Check if the month is fall under which quater using “Nested If” statement and “OR” Operator 'Check whether the number is greater than zero You can use If…ElseIf…Else to check more conditions:Įxample : Check whether the number entered by the user is positive, negative or equal to zero. Num = InputBox("Enter the Number:", "Number") Example 1: Check whether the cell number is greater than six lakhsĮxample 2: Check whether the number is even or odd It will check the Condition, if the condition is True it will execute the Statements1, if False execute the Statements2. It will check if the range C2 value, if it is greater than 600000 it will execute the statement ‘Range(“D2”) = Range(“C2”) * 10 / 100’. It is a simple Condition to check an expression, if the condition is True it will execute the Statement.
Conditional Statements in Excel VBA – Download: Example Fileĭownload this example file, we will learn conditional statements with examples.ĪNALYSISTABS Examples on Conditional Statements IF Statement If.
0 kommentar(er)
