Object Reference
- Classes
- Command Interface
- External
- General
-
System Core
-
xf_Base
-
xf_BaseInstance
-
xf_BaseMin
-
xf_Globals
-
- System Library
xf_BaseInstanceXF Base Module
Public Function nze (
varToTest As Variant,
Optional varIfMt As Variant = Null
) As Variant
Like the built in nz() function, but substitutes second value if mt() is true.
varToTest as Variant
A variant value
Optional varIfMt as Variant = Null
The empty substitution value
Call Template:
Dim v As Variant
v = nze(varToTest)
v = nze(varToTest, varIfMt)
See Also:
Example 1:
nze(Null, "suprise!") => suprise!
nze("", "suprise!") => suprise!
nze("0", "suprise!") => 0 (string)
nze(0, -1) => 0
nze(23, -1) => 23
nze(False, "suprise!") => False