gtd526
Active Member
 Joined
 Jul 30, 2013
 Messages
 477
 Office Version

 2019
 Platform

 Windows
Hello,
Using the index,match formula (D:D), when it returns 0, it's not indicating Less Than 377(C1). How can I get it to indicate Less Than, if true?
Thank you.
Using the index,match formula (D:D), when it returns 0, it's not indicating Less Than 377(C1). How can I get it to indicate Less Than, if true?
Thank you.
NBA.xlsm  

A  B  C  D  E  
1  538  377  161  
2  12/12  Ind %  Avg  
3  Team  H:H  Inj's  Pts  TEST  
4  MIL  5  170  TRUE  
5  NYK  1  226  TRUE  
6  BKN  4  350  TRUE  
7  DET  3  304  TRUE  
8  DAL  3  538  FALSE  
9  OKC  0  0  FALSE  
10  NO  3  0  FALSE  
11  SAN  2  345  TRUE  
12  MIN  1  399  FALSE  
13  POR  4  327  TRUE  
14  ORL  5  258  TRUE  
15  LAL  4  495  FALSE  
Test 
Cell Formulas  

Range  Formula  
B1  B1  =Injuries!A5 
C1  C1  =B1*0.7 
D1  D1  =B1*0.3 
A2  A2  =TODAY() 
B4:B15  B4  =IF($H4="","",ROUND(SUMIFS($AT$7:$BN$142,$AP$5:$BJ$140,$H4),2)) 
C4:C15  C4  =IFERROR(INDEX(Injuries!$2:$2,MATCH($A$4:$A$33,Injuries!$1:$1,0)),"") 
D4:D15  D4  =IFERROR(INDEX(Injuries!$B$16:$EQ$16,MATCH($A4,Injuries!$B$1:$EQ$1,0)+4),"") 
E4:E15  E4  =D4<$C$1 