You could do the following for example:-
Cell W1 =
- Code: Select all
=LEFT(A1,SEARCH(":",A1)+2)
Cell W2 =
- Code: Select all
=LEFT(Sheet1!A1,SEARCH(":",Sheet1!A1)+2)
Then your formula could be as follows.
- Code: Select all
=IF(AND(Sheet1!T5<>"",$W$1=$W$2),"LAY-IP",IF(T5<>"","CLEAR",IF(AK$1<0.0001041666,"",""))))