SOLVED

Need help on IF expression

Copper 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 (Copper 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.

1 best response

Accepted Solutions
best response confirmed by Timothy6225 (Copper Contributor)
Solution
Never mind; I figured it out. Extra parentheses is the trick.

View solution in original post