xxxxxxxxxx
=IF(IFNA(VLOOKUP($C5, Table1[[Full Name ]:[Mocht je op nog certificeringen hebben mag je die hier achterlaten :-)Mocht je er geen bezitten dan mag je hem leeg laten.]], 5, FALSE), 1) = "Value1", "Result1", IF(IFNA(VLOOKUP($C5, Table1[[Full Name ]:[Mocht je op nog certificeringen hebben mag je die hier achterlaten :-)Mocht je er geen bezitten dan mag je hem leeg laten.]], 9, FALSE), 1) = "Value2", "Result2", "OtherResult"))
xxxxxxxxxx
=IF(LEN(TEXT(A1, "0.00")) < LEN(A1), "More than 2 decimals", "Exact or less than 2 decimals")
xxxxxxxxxx
=AND(ISNUMBER(SEARCH("[A-Z]", A1)), ISNUMBER(SEARCH("[a-z]", A1)), ISNUMBER(SEARCH("\d", A1)))
xxxxxxxxxx
=IF(ISNUMBER(FIND("Phước Đồng"; X11)); TRIM(MID(X11; FIND("Thôn"; X11) + LEN("Thôn") + -4; FIND(","; X11; FIND("Thôn"; X11)) - (FIND("Thôn";X11) + LEN("Thôn") - 4))); IF(ISNUMBER(FIND("Phước Đồng"; T11)); TRIM(MID(T11; FIND("Thôn"; T11) + LEN("Thôn") + -4; FIND(","; T11; FIND("Thôn"; T11)) - (FIND("Thôn"; T11) + LEN("Thôn") - 4))); ""))