Forum Discussion
Conditional formatting using formula IF and FIND
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.
4 Replies
Hi Justin,
It could be
=IF(ISNUMBER(FIND("CBL",F2,1)),"CKT","AVEX")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.
Justin, that could be like
=IF(ISNUMBER(FIND("CBL",F2,1))+ISNUMBER(FIND("EXT",F2,1)),"CKT","AVEX")
