![自定义函数错误](https://linux22.com/image/1645020/%E8%87%AA%E5%AE%9A%E4%B9%89%E5%87%BD%E6%95%B0%E9%94%99%E8%AF%AF.png)
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 错误。有什么想法吗?
答案1
IsNull(param1) = True
代替
param1 Is Null