simple formula needed.

[alvbnp]

columnA | columnB
001 | 001
002 | 005
006 | 006

in columnC:
1. if columnA = columnB, show columnA value which is 001
2. if columnA <> columnB, show both column value as 002-005

Thanks.

 

[JohnnyTightlips]

=if(a1=b1,a1,a1&"-"&B1)

dragged down for each row

 

[alvbnp]

Thanks dude.

Another question, anyway i can make it look 002-005? I have set the cell format to 000. For the 1st 001 it show fine. But for the 2nd, it show as 2-5. I would want to to show as 002-005.

Thanks.

 

[JohnnyTightlips]

Assuming you will eventually get to double figures, meaning you can't add 00 to the "-" part of the formula :

One way would be a helper column for column B with the Formula =text(B1,"000") and have the IF Formula reference the helper column rather than Column B

There are likely other ways to achieve this, i throw it open to the forum!

 

[alvbnp]

Thanks. I managed to get it working.

Thanks again.

 

[jindon]

columnA | columnB
001 | 001
002 | 005
006 | 006

in columnC:
1. if columnA = columnB, show columnA value which is 001
2. if columnA <> columnB, show both column value as 002-005

Thanks.

Hi
try

=If(A1=B1,Text(A1,"000"),Text(A1,"000")&"-"&Text(B1,"000")