IIF Statements

  • Thread starter Thread starter DSmith
  • Start date Start date
D

DSmith

How do I use an IIF statement with 2 variables?

Example:
=IIf([Type]="rt" or "instructor" etc.

I'm having trouble with the syntax. Thanks in advance.
 
How do I use an IIF statement with 2 variables?

Example:
=IIf([Type]="rt" or "instructor" etc.

I'm having trouble with the syntax. Thanks in advance.
Click to expand...

=IIf([Type]="rt" Or [Type] = "instructor","Do This","Do That")
 
-----Original Message-----
How do I use an IIF statement with 2 variables?

Example:
=IIf([Type]="rt" or "instructor" etc.

I'm having trouble with the syntax. Thanks in advance.
Click to expand...

=IIf([Type]="rt" Or [Type] = "instructor","Do This","Do That")
--
Fred
Please respond only to this newsgroup.
I do not reply to personal email
.
Click to expand...
Donna & Fred,
I believe there is another way to interpret this question.
If "rt" evokes one response, "instructor" evokes a second
response, and neither "rt" nor "instructor" evokes a third
response:
=IIf ([Type]="rt", "first possibility", IIf ([Type]
="instructor", "second possibility", "third possibility"))

Howard
 
Thanks, guys! That worked fine.

heg said:
-----Original Message-----
How do I use an IIF statement with 2 variables?

Example:
=IIf([Type]="rt" or "instructor" etc.

I'm having trouble with the syntax. Thanks in advance.
Click to expand...

=IIf([Type]="rt" Or [Type] = "instructor","Do This","Do That")
--
Fred
Please respond only to this newsgroup.
I do not reply to personal email
.
Click to expand...
Donna & Fred,
I believe there is another way to interpret this question.
If "rt" evokes one response, "instructor" evokes a second
response, and neither "rt" nor "instructor" evokes a third
response:
=IIf ([Type]="rt", "first possibility", IIf ([Type]
="instructor", "second possibility", "third possibility"))

Howard
Click to expand...
 
Back
Top