IIF Function

[Anthony]

Happy New Year!

My question is, what do you call the use of the IIF function to return a
value?

Like, the word "concatenation" is used when we are referring to the act of
combining two or more variable values.

So, what is the behavior called when we are referring to the act of using
the IIF function to return a value?

 

[Marshall Barton]

My question is, what do you call the use of the IIF function to return a
value?

Like, the word "concatenation" is used when we are referring to the act of
combining two or more variable values.

So, what is the behavior called when we are referring to the act of using
the IIF function to return a value?

Whatever, as the mood moves you. I usually say "call the
IIf function".

Part of the trouble with your question is that concatenation
is an operator used in an expression (like multiplication,
etc), while a function call is an operand that will be
operated on by whatever operators are used in the expression
containing the function call.

 

[Van T. Dinh]

IIf stands for Immediate If ...

I guess if you are looking for the equivalent of "concatenation", you can
use "conditional return".

 

[Keith Wilby]

IIf stands for Immediate If ...

Blimey ... I wonder where I got "in-line if" from. Perhaps I made it up
myself.

Keith.

 

[Marshall Barton]

Blimey ... I wonder where I got "in-line if" from. Perhaps I made it up
myself.

Keith.

No need to get into a dither, Keith ;-) Lots of people use
either one. On the rare ocassions when I'm willing to spell
it out, I can't predict whether I'll use Inline or
Immediate.

 

[Keith Wilby]

No need to get into a dither, Keith ;-) Lots of people use
either one.

Thanks Marsh, I thought for a moment I'd acquired an imagination ;-)

Keith.

<Snip>