compare 2 cells then copy value if they are different

G

Gwen B

I want to compare two cells, 1 contains an address, the other may or may not
contain data. If the 2nd cell is blank I want to copy the address from the
1st cell. Is there a formula to do this?
 
D

David Biddulph

If, in addition to what you have specified, when the 2nd cell is not blank
you want to use the value from the 2nd cell, then try
=IF(B2="",A2,B2) or
=IF(B2<>"",B2,A2)
 
M

Marcelo

it is not possible without an auxiliar column, assuming the formulas that
David sugest you but using it on column C.

or you must to type a different formula in each cell to preserve original
values on column B.

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Gwen B" escreveu:
 
Top