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]

I really need some help with this one, Ive tried everything.

Thanks

 

[jberwald]

Try this formula in B7, I've used 10 as your upper limit, change for what you need.

=IF(AND(A1=1, B1+B2+B3+B4+B5+B6<10),"yes","No")

 

[sobeleg]

Try this formula in B7, I've used 10 as your upper limit, change for what you need.

=IF(AND(A1=1, B1+B2+B3+B4+B5+B6<10),"yes","No")

Thanks, the only issue here is that each of the B values have different specific upper limits. These upper limits are different for each of the five cases.

 

[jberwald]

Sorry - read the question wrong - again I have the limits as 10

=IF(AND(A1=1, B1<10,B2<10,B3<10,B4<10,B5<10,B6<10),"yes","No")

 

[sobeleg]

Thank you, to make this apply for all cases would I just continue like this:

=IF(AND(A1=1, B1<10,B2<10,B3<10,B4<10,B5<10,B6<10),"yes","No"), AND(A1=2, B1<10,B2<10,B3<10,B4<10,B5<10,B6<10),"yes","No").....

 

[jberwald]

Ahhh, now we get the rest of the story.
Are these 5 different questions that you need 5 different answers for? And what version of Excel are you using?

 

[sobeleg]

Basically I need the box to say whether certain information is valid. Each of the five cases, the guidelines are different.

I am using Excel 2007

 

[sobeleg]

Basically I need the box to say whether certain information is valid. Each of the five cases, the guidelines are different.

I am using Excel 2007

To clarify even further, Each case (A1 in my example) is listed in a drop down box.

 

[sobeleg]

Still looking for a way to get this done. All help is greatly appreciated!