Need an expression to return more than 2 values in a control

S

Stu

I need a conditional expression which will return 3
values. IIf is useless to me since it only returns 2
values. Any ideas?

thanks
 
L

Lynn Trapp

IIF is much more flexible than you realize, as you can nest other IIF
statements inside each other.

IIF(<condition1>,<value1>,IIF(<condition2>,<value2>,<value3>))
 
N

Nick Coe \(UK\)

Do it in VBA and use Select Case. Write yourself a function
which you send the values to you're interested in and which
returns the result.

As Yanick said you could nest IIF's though I find them hard
to read.
 
Top