Get instant live expert help on I need help with excel string concatenation

Search thru Column H and Column I, and IF the cell CONTAINs STRING A, STRING B, OR STRING C, return VALUE 1 OR if cell CONTAINs String D, String E, OR STRING F, return VALUE 2, OR if cell CONTAINs String G, OR String H, return VALUE 3 Otherwise, return UNKNOWN.

Write a sub that does the following: It first generates a random winning number and stores it in a string variable (so that you can use string concatenation), and it asks the user how many cards they want to buy. It then uses a For loop to generate that number of cards and store their numbers in a card array (which should be a String array). Next, it uses a Do loop to keep checking cards until a winner has been found or no more cards remain. Finally, it displays a message stating whether you are a winner and your net gain or loss. Note that you can generate a single random digit from 0 to 9 with Excel’s RANDBETWEEN() function.

MY QUESTION IS ABOUT: Fixing Formulas DESCRIPTION: Search thru Column H and Column I, and IF the cell CONTAINs STRING A, STRING B, OR STRING C, return VALUE 1 OR if cell CONTAINs String D, String E, OR STRING F, return VALUE 2, OR if cell CONTAINs String G, OR String H, return VALUE 3 Otherwise, return UNKNOWN.

i need macro coding regarding some multiple string comparision of excel cell strings and show the output

I need to type in a string in a cell to represent a number that will be used in excel calculation