gtd526
Well-known Member
- Joined
- Jul 30, 2013
- Messages
- 657
- Office Version
- 2019
- Platform
- Windows
Hello,
I've added a formula for the W/L (G92 & 93) for each team and it shows 0 when there is no W or L. How can I get it to say "A Blank" (A91) when it shows 0 (G92, G93)?
The A91 formula works when there is no formula in G92 & G93.
Here is the data:
I've added a formula for the W/L (G92 & 93) for each team and it shows 0 when there is no W or L. How can I get it to say "A Blank" (A91) when it shows 0 (G92, G93)?
The A91 formula works when there is no formula in G92 & G93.
Here is the data:
Cell Formulas | ||
---|---|---|
Range | Formula | |
A91 | A91 | =IF(COUNTIF($G92:$G93,"L")>0, "L",IF(COUNTIF($G92:$G93,"")>0,"a blank","W")) |
G92:G93 | G92 | =INDEX('C:\Users\gtd52\Documents\Sports-Wagering\[NFL.xlsm]Weekly Picks'!$E$4:$E$35,MATCH($H92,'C:\Users\gtd52\Documents\Sports-Wagering\[NFL.xlsm]Weekly Picks'!$A$4:$A$35,0)) |
I92:I93 | I92 | =IF(1=MOD(MATCH(H92,'C:\Users\gtd52\Documents\Sports-Wagering\[NFL.xlsm]Weekly Picks'!$A$4:$A$35,0),2),INDEX('C:\Users\gtd52\Documents\Sports-Wagering\[NFL.xlsm]Weekly Picks'!$A$4:$A$35,MATCH(H92,'C:\Users\gtd52\Documents\Sports-Wagering\[NFL.xlsm]Weekly Picks'!$A$4:$A$35,0)+1),INDEX('C:\Users\gtd52\Documents\Sports-Wagering\[NFL.xlsm]Weekly Picks'!$A$4:$A$35,MATCH(H92,'C:\Users\gtd52\Documents\Sports-Wagering\[NFL.xlsm]Weekly Picks'!$A$4:$A$35,0)-1)) |