Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Boolean Question 2

Status
Not open for further replies.

dunkyn

Technical User
Apr 30, 2001
194
US
Regrets - First formula. Assistance appreciated.

If {'56908213$'.F1} <> (&quot;EQUITY&quot; or &quot;FIXED INC&quot;) THEN &quot;CASH&quot;

I get a message that &quot;a Boolean is required here&quot;. Doesn't OR qualify?

Waiting for help files to be installed on my PC.

Thx.

 
Try:

If {'56908213$'.F1} <> &quot;EQUITY&quot;
and
{'56908213$'.F1} <> &quot;FIXED INC&quot; THEN
&quot;CASH&quot;

or

if not({'56908213$'.F1} in [&quot;EQUITY&quot;, &quot;FIXED INC&quot;]) THEN
&quot;CASH&quot;

-k kai@informeddatadecisions.com
 
Try this formula:

if not({'56908213$'.F1} in [&quot;EQUITY&quot;,&quot;FIXED INC&quot;])then &quot;CASH&quot; Mike
If you're not part of the solution, you're part of the precipitate.
 
Thank you both!
The syntax of the second formula is a little confusing to me, but I guess I just need to get acquainted.
Thanks for the help!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top