excel commands
=IF(C2<2,”empty or default data”,IF(AND(C2>2,C2<5),”Between 2 and 5 items”,”Business data exisits”))
Excel version of CONTAINS:
=IF(ISNUMBER(SEARCH(“lists”,G2,1)),”List”,”DocLibrary”)
=IF(C2<2,”empty or default data”,IF(AND(C2>2,C2<5),”Between 2 and 5 items”,”Business data exisits”))
Excel version of CONTAINS:
=IF(ISNUMBER(SEARCH(“lists”,G2,1)),”List”,”DocLibrary”)