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





Kirim email ke