Formula with text help

[coatesy69]

Hi all.

Could anyone please help me with a formula containing text.

Cell A1 contains the item number, Cell B2 contains a description of the item, Cell C2 contains the location of the item.


It would read something like, 1 CAR RADIO: SHOWROOM 1 LOCATION - D25
2 SPEAKER SET: SHOWROOM 1 LOCATION - D26

The formula below works, apart from when I copy down the worksheet. If there are no more items, the cell would just say "SHOWROOM 1 LOCATION"

=B2&" : SHOWROOM 1 LOCATION - "&C2

Do you know how to copy down and leave the cell blank if there are no items in that Cell.

I hope this is not too confusing.

Thanks for any help

Graham

[AliGW]

Maybe this:


=IF(C2="",B2,B2&" : SHOWROOM 1 LOCATION - "&C2)

[coatesy69]

Hi
Thanks for you reply. I tried it but the blank cell returns a 0. It does not stay blank

Thanks

Graham

[JeteMc]

If I understand correctly you want the formula to yield a blank cell if there is no part description, which means that there would not be a location either. If that is correct try:

Please Login or Register  to view this content.

If my understanding isn't correct, it would be helpful to post an example of the conditions that should cause the formula to yield a blank cell.
Let us know if you have any questions.

[coatesy69]

Thank you very much for this. It is perfect.

Regards,

Graham

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[JeteMc]

You're Welcome and thank you for the feedback. I hope that you have a blessed day.