Conditional formatting using formula IF and FIND

[Justin Hsu]

Dear Sir,

Could you help me to create new formulas for Column A (Scope), thank you.

Detail as below :

if the string of cable name include "CBL" or "EXT" then will show CKT on Column A (Scope), otherwise will show "AVEX".

Thank you so much for help.

[#2]

Hi Justin,

It could be

=IF(ISNUMBER(FIND("CBL",F2,1)),"CKT","AVEX")

[#3]

Hi Sergei,

Thank you so much for quick help.

one more question, is it possible to add two conditions "CBL", "EXT" in this formula.

if find any string include "CBL" or "EXT", then will show "CKT", otherwise will show "AVEX"

Thank you for great support.

[#4]

Justin, that could be like

=IF(ISNUMBER(FIND("CBL",F2,1))+ISNUMBER(FIND("EXT",F2,1)),"CKT","AVEX")

[#5]

Hi Sergei,
Really appreciate for great help.

Best Regards
Justin