A
Andrew
Folks can anyone answer a simple question for me?
Has anyone used in-line IF's much? If so, do you know when they terminate
when nested? Is it when the first condition is true or does it evaluate the
whole string? Ie:
IIF(x>0, z1, IIF(x+1>0, z2, IIF(x+2>0, z3, z4)))
If x = 1 will that IIF return z1 (stopping as soon as x>0 is true) or z3
(going all through to when x+2>0 is true) ?
Thanks for any help.
Has anyone used in-line IF's much? If so, do you know when they terminate
when nested? Is it when the first condition is true or does it evaluate the
whole string? Ie:
IIF(x>0, z1, IIF(x+1>0, z2, IIF(x+2>0, z3, z4)))
If x = 1 will that IIF return z1 (stopping as soon as x>0 is true) or z3
(going all through to when x+2>0 is true) ?
Thanks for any help.