Originally Posted by Paul_Hossler 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.
Be as you wish to seem
View Tag Cloud
Forum Rules