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!! |