# 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.

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)

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)

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?

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1