Hello everyone!
I really need your help!
This is my problem: I have 2 columns with 2 different values (2 different numbers, a number and a 0, a number and a N/A error), like this:
A B
1 2
1 0
0 2
1 N/A
What I need is the C column to take the value of the column A, if there's a number in both columns, the value of A if B equals O or N/A, and the value of B if A equals 0 or N/A.
Thank you so much!
Mya
I really need your help!
This is my problem: I have 2 columns with 2 different values (2 different numbers, a number and a 0, a number and a N/A error), like this:
A B
1 2
1 0
0 2
1 N/A
What I need is the C column to take the value of the column A, if there's a number in both columns, the value of A if B equals O or N/A, and the value of B if A equals 0 or N/A.
Thank you so much!
Mya