Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!! |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!! |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|