Mungkin ini bisa membantu. Function check(EMP As String, BRANCH As String, TPE As String) If EMP = "SALARIED" And TPE = "1" And Len(BRANCH) = 0 Then check = "OK" ElseIf EMP <> "SALARIED" And TPE = "1" And Len(BRANCH) = 0 Then check = "not ok" End If End Function
-----Original Message----- From: [email protected] [mailto:[email protected]]on Behalf Of Arora, Aman (GE Money) Sent: Friday, February 06, 2009 1:26 AM To: [email protected] Subject: ]] XL-mania [[ Function is not picking Blank Hi, Please help, Function is not picking blank cell. enclosed dummy data Regards Aman S Arora

