If, And,Or?

[Guest]

Hello,
Here is my function:
=IF(AND(BA7<4,BB7<4.25),INDEX(A235:J235,MATCH(N115,A234:J234,0)),"")

The trouble is that it would be possible for BA7to=1, and BB7 to be >4.25.
This could only happen if BA7 were to =1. If this were the case I would still
like to preform the Index,Match.

Any Ideas?

Thanks in advance!!

 

[Biff]

Hi!

=IF(OR(AND(BA7<4,BB7<4.25),AND(BA7=1,BB7>4.25)),INDEX.......................)

What if BB7 = 4.25?

Biff

 

[Guest]

Good morning Biff, Thank you for your help it seems to be working great! To
answer your question BB7 needs to be 4 or less. So if it's 4.25 it's
eliminated.

Thanks again for your help!

 

[Biff]

You're welcome. Thanks for the feedback!

Biff

Good morning Biff, Thank you for your help it seems to be working great!
To
answer your question BB7 needs to be 4 or less. So if it's 4.25 it's
eliminated.

Thanks again for your help!

 

[Guest]

Hello again, I have a question. In the solution that you gave me is
(BA7<4,BB7<4.25) the "AND" or the "OR"? And more importantly can we make it
the "OR"? It seems to me that both need to be true to start the INDEX,MATCH.
could it be either instead?

 

[Guest]

In fact now that I think of it this solution would eliminate the need for the
second "AND" as BA1=1 would be picked up by BA1 being <4....Right?

 

[Biff]

Hi!

is (BA7<4,BB7<4.25) the "AND" or the "OR"?

Actually, it's both. The AND is an argument to the OR.

You explained this is what you wanted:

It allows for these 2 possible situations

BA7<4 and BB7<4.25

OR

BA7=1 and BB7>4.25

Biff

 

[Biff]

In fact now that I think of it this solution would eliminate the need for

the
second "AND" as BA1=1 would be picked up by BA1 being <4....Right?

But then it wouldn't meet the criteria if BB7>4.25 as you stated that it
could be but only if BA7=1.

Biff