gtd526
Well-known Member
- Joined
- Jul 30, 2013
- Messages
- 657
- Office Version
- 2019
- Platform
- Windows
Hello,
I'm trying to resolve a formula.
=IF(AND(($B2<0),($D2>$B2*-1)),"Yes", "")
When B2 & B3=pk (as below), its not recognized as a number.
How can I turn pk to 0 in the formula above?
I just want to see if the MOV (margin of victory) is > the spread (B:B).
Thank you.
I'm trying to resolve a formula.
=IF(AND(($B2<0),($D2>$B2*-1)),"Yes", "")
When B2 & B3=pk (as below), its not recognized as a number.
How can I turn pk to 0 in the formula above?
I just want to see if the MOV (margin of victory) is > the spread (B:B).
Thank you.
Book1 | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | Teams | ATS | Cover % | MOV | ATS +/- | MOV > ATS | ||
2 | IND | pk | 75% | 12 | 5.1 | #VALUE! | ||
3 | CLE | pk | 50% | 0 | -1.2 | #VALUE! | ||
4 | MIA | 8.0 | 50% | -1 | 4.2 | |||
5 | SF | -8.0 | 50% | 9 | 2.6 | Yes | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
C2:C5 | C2 | =IFERROR(VLOOKUP($A2,'[NFL.xlsm]ATS Trends'!$A$2:$F$43,4,0),"") |
D2:D5 | D2 | =IFERROR(VLOOKUP($A2,'[NFL.xlsm]ATS Trends'!$A$2:$F$65,5,0),"") |
E2:E5 | E2 | =IFERROR(VLOOKUP($A2,'[NFL.xlsm]ATS Trends'!$A$2:$F$44,6,0),"") |
F2:F5 | F2 | =IF(AND(($B2<0),($D2>$B2*-1)),"Yes", "") |