# Double conditional check **Category:** [Yahoo Archive](https://www.epiusers.help/c/yahoo-archive/9) **Created:** 2001-03-28 14:21 UTC **Views:** 523 **Replies:** 3 **URL:** https://www.epiusers.help/t/double-conditional-check/2567 --- ## Post #1 by @system
Thank you.

-----Original Message-----
From: Terry Williams [SMTP:tlw@...]
Sent: Wednesday, March 28, 2001 12:27 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Double conditional check

In the expression part of a calculation use:

IIF(x>6,IIF(x<10,"true for both","false for x<10"),"false for x>6")

This is called a nested IIF. We programming types us it all the time.

Terry L. Williams Chipsco, Inc. 9936 Liberty St. Ext. Meadville, PA
16335 814-333-6331 fax: 814-337-2548 tlw@...
<mailto:tlw@...> www.chipsco.com <http://www.chipsco.com/>

-----Original Message-----
From: Oleg Tumarkin [mailto:otumarkin@...]
Sent: Wednesday, March 28, 2001 1:06 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Double conditional check

I am trying to use a report builder to do some caculations for me and can't
figure out how can I test if x>6 and x<10 type statement. From what I can
tell by reading help files there is no and/or logic in the IIF statements
or in their logic functions, if I am blindly missing it please point me to
how I can do it.

Thank you

Oleg Tumarkin




Yahoo! Groups Sponsor
Click Here to Find Software Faster
Click Here to Find Software Faster
<http://rd.yahoo.com/M=162801.1342103.2934627.1280005/D=egroupmail/S=170
0007
183:N/A=599089/*http://www.knowledgestorm.com/jump_white.html?c=Yahoo&n=
eLer
t_ComputersInternet_Software_WhiteGridOptions&t=ad>


To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .


[Non-text portions of this message have been removed]



To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
--- ## Post #2 by @system
I am trying to use a report builder to do some caculations for me and can't
figure out how can I test if x>6 and x<10 type statement. From what I can
tell by reading help files there is no and/or logic in the IIF statements
or in their logic functions, if I am blindly missing it please point me to
how I can do it.

Thank you

Oleg Tumarkin
--- ## Post #3 by @system
Oleg,

Try: iif(x > 6 and x < 10, true value, false value)

HTH
Jim Stetter
-----Original Message-----
From: Oleg Tumarkin [mailto:otumarkin@...]
Sent: Wednesday, March 28, 2001 1:06 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Double conditional check


I am trying to use a report builder to do some caculations for me and
can't
figure out how can I test if x>6 and x<10 type statement. From what I can
tell by reading help files there is no and/or logic in the IIF statements
or in their logic functions, if I am blindly missing it please point me to
how I can do it.

Thank you

Oleg Tumarkin


Yahoo! Groups Sponsor

Click Here to Find Software Faster


To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
--- ## Post #4 by @system
In the expression part of a calculation use:

IIF(x>6,IIF(x<10,"true for both","false for x<10"),"false for x>6")

This is called a nested IIF. We programming types us it all the time.

Terry L. Williams Chipsco, Inc. 9936 Liberty St. Ext. Meadville, PA
16335 814-333-6331 fax: 814-337-2548 tlw@...
<mailto:tlw@...> www.chipsco.com <http://www.chipsco.com/>

-----Original Message-----
From: Oleg Tumarkin [mailto:otumarkin@...]
Sent: Wednesday, March 28, 2001 1:06 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Double conditional check

I am trying to use a report builder to do some caculations for me and can't
figure out how can I test if x>6 and x<10 type statement. From what I can
tell by reading help files there is no and/or logic in the IIF statements
or in their logic functions, if I am blindly missing it please point me to
how I can do it.

Thank you

Oleg Tumarkin




Yahoo! Groups Sponsor
Click Here to Find Software Faster
Click Here to Find Software Faster
<http://rd.yahoo.com/M=162801.1342103.2934627.1280005/D=egroupmail/S=1700007
183:N/A=599089/*http://www.knowledgestorm.com/jump_white.html?c=Yahoo&n=eLer
t_ComputersInternet_Software_WhiteGridOptions&t=ad>


To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .


[Non-text portions of this message have been removed]
--- **Canonical:** https://www.epiusers.help/t/double-conditional-check/2567 **Original content:** https://www.epiusers.help/t/double-conditional-check/2567