Compare two columns (and ignore 0)

[Mandy_]

Hi,

I'm trying to compare two columns with numerals.

Compare column A against B.
If column A = 0, then answer is from column B

Then for the remaining data I wish to compare column A next to B, and only if the values aren't equal to each other, then grab column A answer, otherwise column B answer.
(And if they aren't equal it doesn't matter I just need the value.)

I'm having trouble writing the formula and would appreciate some help please.

Thank you,

 

[Fluff]

How about

=IF(A2=0,B2,A2)

 

[Mandy_]

Thank you!

How does that formula know what to do when the cells are equal?

 

[Joe4]

How does that formula know what to do when the cells are equal?

As you said, it doesn't matter when they are equal, it can pull either one.
So I don't think you have any concerns there.

 

[Fluff]

If the cells are the same it doesn't matter which one it uses.