Link to home
Start Free TrialLog in
Avatar of Chi Is Current
Chi Is CurrentFlag for United States of America

asked on

Multiple, Independent IIf Statements in One Expression

Looking for a way to write multiple, INDEPENDENT iif statements in one expression (in a text box).
Example: IIf(Field1 = x, "1", "2") OR IIf(Field2 = x, "3", "4")  OR IIf(Field3 = x, "5", "6")...

Comparing 3 different and unrelated fields.
All three statements could be true, in which case the result would look like: 135

Heading for dreamtime now; imagining a better solution out there.
Thank you all in advance.
Will return in AM.

Health ~ Jacob
ASKER CERTIFIED SOLUTION
Avatar of Robert Sherman
Robert Sherman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Chi Is Current

ASKER

Nothing like elegant simplicity.
Beautiful!!!

Thank you ~ Jacob