In Excel, how can I let 1 * a = a?

[Michael]

Hi everyone,

Say I have two cells, one has a value (0 or 1), and the second has a
text abrevation such as a or b,....etc.

A B
1 ab
0 ca
1 dd
1 ww


When I type A1*B1, for example, I get #VALUE! stuff!!

How can let it come out like this?

ab
0
dd
ww

Regards,
Mike

 

[Juan Pablo González]

=IF(A1, B1, A1)

should do it

or more explicitly

=IF(A1=1, B1, 0)

 

[Casey]

Michael,
Try this:
IF(A1=1,B1,0)
HT

 

[Frank Kabel]

Hi Mike
what are you trying to achieve?.