0

Hello I need your help with a simple Excel issue:


This is what I have


COLUMN 1 COLUMN 2 COLUMN 3
125 YES
304 NO
1549 YES


Here is what I need:

If the string in COLUMN 2 is 'YES', copy the value in COLUMN 1 to COLUMN 3.

What would the formula for this be? I got this but it just gives me a FALSE value...

=IF(A2="YES";A3=A1;A3=0)

Thank you

PS. I'm using Excel 2007, if that helps.

Edited by G_S: n/a

2
Contributors
2
Replies
3
Views
6 Years
Discussion Span
Last Post by G_S
0

In cell C2, paste:

=IF(B2="YES",A2, "")

Then highlight from C2 down to the end of your data and hit Ctrl-D. That will copy the formula and automatically change the references.

0

In cell C2, paste:

=IF(B2="YES",A2, "")

Then highlight from C2 down to the end of your data and hit Ctrl-D. That will copy the formula and automatically change the references.

Execellent, it worked perfectly, thank you very much.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.