Hi,
I am new to VB and would like to know how I can change my excel formula to VB?
this is my formula:
=IF(A3="Telkom","TGE",IF(ISNUMBER(SEARCH("mobile",A3)),"MOB",IF(ISNUMBER(SEARCH("ambulance",A3)),"TSC",IF(ISNUMBER(SEARCH("toll free n",A3)),"TSC",IF(ISNUMBER(SEARCH("toll free p",A3)),"TSC",IF(ISNUMBER(SEARCH("telkom spec",A3)),"TSC",IF(ISNUMBER(SEARCH("telkom univ",A3)),"TNG",IF(ISNUMBER(SEARCH(" e toll free",A3)),"TNG","OLO"))))))))
Any help is appreciated.
Adriaan.
I am new to VB and would like to know how I can change my excel formula to VB?
this is my formula:
=IF(A3="Telkom","TGE",IF(ISNUMBER(SEARCH("mobile",A3)),"MOB",IF(ISNUMBER(SEARCH("ambulance",A3)),"TSC",IF(ISNUMBER(SEARCH("toll free n",A3)),"TSC",IF(ISNUMBER(SEARCH("toll free p",A3)),"TSC",IF(ISNUMBER(SEARCH("telkom spec",A3)),"TSC",IF(ISNUMBER(SEARCH("telkom univ",A3)),"TNG",IF(ISNUMBER(SEARCH(" e toll free",A3)),"TNG","OLO"))))))))
Any help is appreciated.
Adriaan.