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