Macro to change text in cell if it detects any value in another cell in the same row

[Misbah211]

Hi, I'm basically trying to change the text in cell if it detects any value in another cell, however if the the row is completely empty then it should stay blank.

Eg. If Column C has any value then Column D should say "Associated with Siebel No", if Column C is empty then Column D should say "No Siebel No" in the corresponding row. Also if the entire row is blank then Column D should also stay blank.

I tried a simple IF statement in Column D =IF(O15=0,"No Siebel Number","Associated with Siebel Number") but that that does not work the way I want it and neither am I good at making macros from scratch.

I hope this makes sense, I've attached a sample of my database below to help.


Example.xlsm

I appreciate any help
Thanks in advance!

[TMS]

You don't need a macro.

In your example:

D4: =IF(COUNTA($B4:$C4)=0,"",IF($C4="","No Siebel Number","Associated with Siebel Number"))


Regards, TMS

[Misbah211]

Thanks alot mate

[TMS]

You're welcome.