Write an If...Then...Else statement that displays the string "Columbia" in the lblCapital control when the txt State control contains the string "SC" (in any case). 2. Write an lf...Then...Else statement that displays the string "Please enter ZIP code" in the lblMsg control when the txt Zip control does not contain any data. 3. Write an If...Then...Else statement that displays the string "Incorrect quantity" in the IblMsg control when the intQuantity variable contains a number that is less than 0; otherwise, display the string "Valid quantity" 4. Write an If...Then...Else statement that displays the string "Time to reorder" in the IblMsg control when the intInStock variable contains a number that is less than 250; otherwise, display the string "We have enough in stock". 5. Write an lf...Then...EIse statement that assigns the number 35 to the intCommi ssi on variable when the decSales variable contains a number that is less than or equal to $250; otherwise, assign the number 50