Categories problem

Mya28

New member
Joined
Sep 9, 2013
Messages
1
Reaction score
0
Points
0
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
 
Top