Mark Shamoun said: One great enhancement would be to be able to insert a fail value into the IIF statements
An iif test doesn't 'fail'. Either the test is true or the test fails. There's no third option.
A switch statement, on the other hand, explicitly…