What are nested conditions?

Nested conditions comprise condition statements contained within the definition of other condition statements. Nested conditions work as follows:

• You can group multiple condition statements. Conditions consisting of multiple statements are connected using the logical AND and OR operators.

• You can also nest statements, so that one statement is contained within the definition of another statement.

For example, you might want to find data for the year 2000, where either the Region equals Eastern and Profits are greater than $900,000, or where the Region equals Northern and Profits are greater than $500,000.