simple if statement question

[SMAlvarez]

Ok lets say I have an area for STATE, AGE, and SALARY. And I want it to be like this:

1. state = new york
2. age = greater then 40
3. and salary greater then 20000

Do I need 3 actual if statements? or 3 ands?

thanks for the help!

 

[fredericofonseca]

mixture of AND and IF's, but what you want there is still not very clear.

Please post what you have tried so far, along with sample data, and sample output based on the data you supply.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[SMAlvarez]

I just need help with the if statement

ie:

if state = 'NEW YORK' AND salary > 20000 AND age > 40

can you use two ands like that? or is there another way?

 

[SMAlvarez]

anyone?

 

[Glenn9999]

uhhh...you basically got it... I like to put ()'s on each condition, more for readability than anything else.

 

[webrabbit]

With only ANDs or only ORs, parentheses serve no purpose whatsoever.