(06-05-2023, 04:47 PM)CharlieJV Wrote:(06-05-2023, 04:26 PM)bplus Wrote: I ask because IFF typically takes a numeric expression that evaluates to "True" or "False" numerically -1 or 1 and 0 for false.
That's incorrect.
The first parameter in IFF is an expression that results in an integer number (or any number, really; the number will get treated as an integer).
The expression in the first parameter of IFF could be as simple as a literal number, or a numeric constant, or a numeric variable. Or it could be a function that returns a number. Or it could be any kind of complex expression that results in a number.
Huh, and now I'm also incorrect.
Just tried, and:
If the first expression is a null string, then FALSE expression happens..
If the first expression is a non-null string, then TRUE expression happens.
This has me thinking: potential use cases?
Ooooooo:
Code: (Select All)
IFF( name$, name$, "Guest")