If cell contains data, then copy value from another cell only if it also contains data

[Mux99]

The formula below works but returns 0 when B2 is empty. What I'm trying to do is if B5 contains data then copy B2 only if B2 also contains data, if B2 is empty I would need the cell where I have the formula to stay blank too and not show 0.

=IF(B5<>"", B2,"")

Thanks

 

[kweaver]

How about:

=IF(AND(B2<>"",B5<>""),B2,"")

 

[Mux99]

=IF(AND(B2<>"",B5<>""),B2,"")

Works perfectly, thanks.