自定义函数错误

Question

Function IFBLANK(param1 As Variant, param2 As Variant) As Variant
    If param1 = "" Or param1 Is Null Then
        IFBLANK = param2   
    Else
        IFBLANK = param1   
    End If 
End Function

我收到 #VALUE 错误。有什么想法吗？

Answer 1

IsNull(param1) = True

代替

param1 Is Null