Add text to cell if other cell has contents

[WesternGal]

Hello!

I am trying to add a "label" to my columns.

I need a formula or macro that: If there is anything, text or numbers, in cell B2, add the label "CS" to cell B1.

This is as close as I've come so far, but it adds "CS" even when there isn't anything in cell B2.

Please Login or Register  to view this content.

Does anyone know what I need to fix so it only adds the label if there is something in cell B2?

Thanks!

[ragulduy]

Try:
=If(B2="","","CS")

[powdow]

Try:
=IF(ISBLANK(B2),"","CS")

[WesternGal]

Thank you, works perfectly!