SOLVED

Need help on IF expression

%3CLINGO-SUB%20id%3D%22lingo-sub-1913599%22%20slang%3D%22en-US%22%3ENeed%20help%20on%20IF%20expression%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1913599%22%20slang%3D%22en-US%22%3E%3CP%3EWhat%20I'm%20trying%20to%20do%20is%20not%20among%20the%20examples%20in%20the%20Help%20section.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20say%20IF%20cell%20%231%20contains%20the%20word%20%22YES%22%2C%20copy%20the%26nbsp%3B%3CU%3Evalue%3C%2FU%3E%20of%20cell%20%232%20into%20cell%20%233%2C%20where%20%22cell%20%233%22%20is%20the%20cell%20containing%20the%20formula%20I%20need.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20screen%20shot%20supplied%2C%20in%20J149%2C%20because%20I49%20is%20a%20%22YES%22%2C%20I%20want%20the%206%20in%20F149%20to%20appear%20in%20(be%20copied%20to)%20J149.%26nbsp%3B%20You%20can%20see%20what%20I%20tried%2C%20but%20it%20returns%20an%20error%20message.%26nbsp%3B%20Anyone%20can%20help%3F%20I'm%20guessing%20there's%20some%20punctuation%20mark%20that%20needs%20to%20surround%20the%20%22F149%22%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1913599%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1913884%22%20slang%3D%22en-US%22%3ERE%3A%20Need%20help%20on%20IF%20expression%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1913884%22%20slang%3D%22en-US%22%3ENever%20mind%3B%20I%20figured%20it%20out.%20Extra%20parentheses%20is%20the%20trick.%3C%2FLINGO-BODY%3E
New Contributor

What I'm trying to do is not among the examples in the Help section.

 

I want to say IF cell #1 contains the word "YES", copy the value of cell #2 into cell #3, where "cell #3" is the cell containing the formula I need.

 

In the screen shot supplied, in J149, because I49 is a "YES", I want the 6 in F149 to appear in (be copied to) J149.  You can see what I tried, but it returns an error message.  Anyone can help? I'm guessing there's some punctuation mark that needs to surround the "F149"?

3 Replies
Best Response confirmed by Timothy6225 (New Contributor)
Solution
Never mind; I figured it out. Extra parentheses is the trick.

@Timothy6225 

Hi there,

Please note attached file.

I think it can help you.

 

 

P.S. If you fond my answer as your best solution, please mention it.

 

@Ilgar_Zarbaliyev 

 

Thank you, Ilgar, I see what you did.

Interestingly, I achieved what I needed with a different solution.