# If Statement

1. ## If Statement

First, I am placing the IF statement in Column C. My text string is in Column A, within that string, the text I want to be searched is (I). If (I) this is true I want the number value in Column B to result in Column C. If (I) is not in the text string, meaning false, then I want Column B to be multiplied by 2 putting result in Column C.

I hope this makes it a bid clearer.  Register To Reply

2. ## Re: If Statement

hi Kalief. a more detailed example would help. are you looking for the letter "I" without the brackets or with? what number value do you want? assuming it's with the brackets, the number value is 10, then:
=IF(COUNTIF(A2,"*(I)*"),10,B2*2)  Register To Reply

3. ## Re: If Statement

With the brackets. I already tried the following formulas

=IF(ISNUMBER(SEARCH("*-(I)*",A2,B2)),B2*2)

=IF(ISNUMBER(SEARCH("*-(i)*",a7,1)),3000,B7*2)  Register To Reply

4. ## Re: If Statement

Forgot to answer your other questions. You said, "what number value do you want? assuming it's with the brackets, the number value is 10.

Answer: I want the number value in the corresponding cell in B column, from if cell B2 has a value of 10, and the statement is true then I want cell c2 to reflect 10.

If the statement is false then I want B2*2 and reflect in cell C2, which should be 20 (10 x 2). Make sense?  Register To Reply