Nested / Multiple condition statements

Hi,

I am struggling at getting this multiple if statement working but I am not sure if the method I am using is actually correct because as soon as it hits a certain if statement line and the answer is incorrect then it is giving the false value back instead of going to the next if statement.

I have 4 variables and the rule are:

Variable 1: Can either be Yes or No
Variable 2: Can either be Yes or No
Variable 3: Can be any number
Variable 4: Can be any number

Rule 1: IF variable 1 is Yes AND variable 2 is Yes AND variable 3 >= variable 4 then Do something;
Rule 2: IF variable 1 is Yes AND variable 2 is Yes AND variable 3 < variable 4 then Do something;

Rule 3: IF variable 1 is No AND variable 2 is Yes AND variable 3 >= variable 4 then Do something;
Rule 4: IF variable 1 is No AND variable 2 is Yes AND variable 3 < variable 4 then Do something;

Rule 5: IF variable 1 is Yes AND variable 2 is No then Do something; (this is because if variable 2 is No then it doesnt matter what variable 3 and 4 are, so do something now)
Rule 6: IF variable 1 is No AND variable 2 is No then Do something; (this is because if variable 2 is No then it doesnt matter what variable 3 and 4 are, so do something now)

The way I have done this is, if v1 and v2 are both yes and if v3<v4 then do an action by outputting "rule 2 met", else output "rule 1 met"

The same goes for the other rules but if I change the variable 2 to No then it does not meet the condition:

HTML Code: 

I think I am approaching this wrong, I think I need a if then elseif if its possible in excel?

Maybe this?

Formula:

Please Login or Register  to view this content.

BSB

Hi thanks so much for that it seemed to work!

Was the issue because I was putting an expected false upon each if statement so if either of the first few lines were getting false then it would stop processing?

Yes, exactly that. When nesting IFs the "value if false" parameter should be your next IF and you only have a value if false at the end which shows if none of the other logical tests return true.

BSB

Ah ok thanks everyone for your help, I did initially think that was the problem but when I tried to edit any of my "false" values in either line then excel just through an error saying too many arguments and was hard to see where.

I thought I did attach the file did it not come through as an image?

The image was there. Trevor's point was it's easier to help with a sample file than it is a picture of one.

BSB

Ah ok got you will keep that in mind for future ref. Thanks everyone will close this thread now.

No problem. Glad we could help

BSB