asked on

IIf statment with two variables

I am trying to get this to work but it always shows NO

=IIf([Text17]="NIKON COOLPIX 2 YEAR WARR" OR "NIKON COOLPIX 3 YEAR WARR","YES","NO")

Thanks for the help!
Ward

ASKER CERTIFIED SOLUTION

med39

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Harisha M G

Hi camco,
=IIf([Text17]="NIKON COOLPIX 2 YEAR WARR" OR [text17] ="NIKON COOLPIX 3 YEAR WARR","YES","NO")

Bye
---
Harish

Harisha M G

med39,
You are very fast !!

camco,
You can use "And", "Or" and "Not" operators to logically join more than one conditions :)

Arthur_Wood

could also be done like this:

=IIf([Text17]="NIKON COOLPIX 2 YEAR WARR", "YES",IIF([Text17] = "NIKON COOLPIX 3 YEAR WARR","YES","NO"))

using nested IIF() function calls.

AW

EricJamesOlson

how about using a string compare function instead.

IIF((StrComp([Text17],"NIKON COOLPIX 2 YEAR WARR") = 0) OR (StrComp([Text17],"NIKON COOLPIX 3 YEAR WARR") = 0),"YES,"NO")

and another suggestion, use the entire Text17 name, referencing forms collection and form name, (ie. [Forms]![frmMyFORM]![Text17])

camco

ASKER

Wow that was fast! Thanks for the help.

Ward

Harisha M G

camco, you should have selected the first comment as the answer or should have split the points

med39

Harish,

Thanks for your fairness. I appreciate it.

-med39

Harisha M G

Or did you select mine as the answer because of the next comment?

Harisha M G

med39, please post a question in CS to select your comment as the answer or to split.

camco