CASE statements and IIF statements are syntactical variations of the same thing. Case statements have the same limitation.

What bugs me is that nowhere can I find specific mention of that fact

Also, no one is complaining about this horrible ommission.

Makes me suspect I am missing somthing.

Stored procedures perhaps?

I guess I can create a stored procedure by a SQL call.

Does anybody do that?