Quote Originally Posted by Paul_Hossler View Post
which is a one line If / Then / Else
Not exactly - IIf always evaluates all the expressions, unlike an If..Then. It's more like the IFS function in Excel.

I only suggested it because Ted seemed to want to get away from the 6=5 construction.