I have tried the statements below and many others. Can not seem to get it.
Attempt 1:
=IF(AR2<>"",(IF(Exact(K2,AR2)),"PPDS OK",(IF(Left(K2)="T"),"MRP OK","MRP NOK")),"PPDS NOK")
Attempt 2:
=IF(AND(AR10<>"",K10<>AR10,(LEFT(K10,1)="T")),"MRP OK",IF(AND(AR10<>"",K10<>AR10,(LEFT(K10,1)<>"T")),"MRP NOK",IF(AND(AR10<>"",K10=AR10),"PPDS NOK")))
Basically, it should say” If AR2 is equal to blank, enter test "PPDS NOK" (black text), if not equal to blank, run other check. The “other check” is to see if K2 and AR2 are equal, if they are, enter text "PPDS OK" (blue text), if not, check K2 to see if it starts with the letter T and enter text "MRP OK" if it does or "MRP NOK" if it does not.
Any help greatly appreciated. Thank you!
Attempt 1:
=IF(AR2<>"",(IF(Exact(K2,AR2)),"PPDS OK",(IF(Left(K2)="T"),"MRP OK","MRP NOK")),"PPDS NOK")
Attempt 2:
=IF(AND(AR10<>"",K10<>AR10,(LEFT(K10,1)="T")),"MRP OK",IF(AND(AR10<>"",K10<>AR10,(LEFT(K10,1)<>"T")),"MRP NOK",IF(AND(AR10<>"",K10=AR10),"PPDS NOK")))
Basically, it should say” If AR2 is equal to blank, enter test "PPDS NOK" (black text), if not equal to blank, run other check. The “other check” is to see if K2 and AR2 are equal, if they are, enter text "PPDS OK" (blue text), if not, check K2 to see if it starts with the letter T and enter text "MRP OK" if it does or "MRP NOK" if it does not.
Any help greatly appreciated. Thank you!