If, And,Or?
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!! |
If, And,Or?
Hi!
=IF(OR(AND(BA7<4,BB7<4.25),AND(BA7=1,BB74.25)),IN DEX.......................) What if BB7 = 4.25? Biff "M.A.Tyler" <Great Lakes State wrote in message ... 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!! |
If, And,Or?
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" wrote: Hi! =IF(OR(AND(BA7<4,BB7<4.25),AND(BA7=1,BB74.25)),IN DEX.......................) What if BB7 = 4.25? Biff "M.A.Tyler" <Great Lakes State wrote in message ... 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!! |
If, And,Or?
You're welcome. Thanks for the feedback!
Biff "M.A.Tyler" <Great Lakes State wrote in message ... 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" wrote: Hi! =IF(OR(AND(BA7<4,BB7<4.25),AND(BA7=1,BB74.25)),IN DEX.......................) What if BB7 = 4.25? Biff "M.A.Tyler" <Great Lakes State wrote in message ... 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!! |
If, And,Or?
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? "Biff" wrote: Hi! =IF(OR(AND(BA7<4,BB7<4.25),AND(BA7=1,BB74.25)),IN DEX.......................) What if BB7 = 4.25? Biff "M.A.Tyler" <Great Lakes State wrote in message ... 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!! |
If, And,Or?
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? "M.A.Tyler" wrote: 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!! |
If, And,Or?
Hi!
=IF(OR(AND(BA7<4,BB7<4.25),AND(BA7=1,BB74.25)),IN DEX.......................) 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: 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. It allows for these 2 possible situations BA7<4 and BB7<4.25 OR BA7=1 and BB74.25 Biff "M.A.Tyler" <Great Lakes State wrote in message ... 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? "Biff" wrote: Hi! =IF(OR(AND(BA7<4,BB7<4.25),AND(BA7=1,BB74.25)),IN DEX.......................) What if BB7 = 4.25? Biff "M.A.Tyler" <Great Lakes State wrote in message ... 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!! |
If, And,Or?
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 BB74.25 as you stated that it could be but only if BA7=1. Biff "M.A.Tyler" <Great Lakes State wrote in message ... 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? "M.A.Tyler" wrote: 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!! |
All times are GMT +1. The time now is 04:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com