If Statement Question

[sobeleg]

I am trying to create an if statement that automatically says yes or no depending on if the five boxes are within a valid range for certain cases. If any of those boxes are not in that range for each of five specific cases, it will say no.

Basically:

IF A1 = Case 1 and B 2, 3, 4, 5, and 6 are within a certain range (less than an upper limit), then B7 = "Yes", and so on for five cases.

Any help would be greatly appreciated, Thanks!

 

[sobeleg]

Can someone please help me finish this up?

IF(AND(B10="Shipper", F20<=64,F21<=24,F22<=20,F24<=50),"yes","No")

I have this part of the statement, I just need to extend it to have 5 options for values for B10, and different guidlines (F cells) based on what B10 says.

Thank you.

 

[water1355]

I'm sure there must be better ways, but you could use nested if statements like:

If(And(),"Yes",If(And(),"Yes",If(And(),"Yes",If(And(),"Yes",If(And(),Yes","No")))))

where you'd substitute actual tests for each of the And() statement above, that is, you'd use your actual tests like are in your example:

AND(B10="Shipper", F20<=64,F21<=24,F22<=20,F24<=50)

Basically, you're just putting another if statement where the "No" goes until you get to the innermost if statement, where you actually put the "No" result. Excel evaluates the outer If() statement first, and if true, gives you a "Yes" response. If false, it the evaluates the second inner If() statement, and so on, until get a true response or if all the statements are false, it will return a "No" from the innermost If() statement.

 

[sobeleg]

I just figured out a way of doing this. Thank you to everyone who helped me out!