Forum Discussion
Stephanie James
Sep 13, 2017Copper Contributor
Multiple IF function
Here's what my tables look like to calculate betting spreads. What I'm trying to accomplish is to have A2 display "DO NOT PLAY" if my Spread (D14) and the DE Spread (D15) differs by less...
- Sep 13, 2017
Hi Stephanie,
Do you mean somehing like this?
=IF(ABS(D14-D15)<2, "DO NOT PLAY", IF(ABS(D15)>ABS(D14),D2,B2) )
SergeiBaklan
Sep 13, 2017Diamond Contributor
Hi Stephanie,
Do you mean somehing like this?
=IF(ABS(D14-D15)<2, "DO NOT PLAY", IF(ABS(D15)>ABS(D14),D2,B2) )
Stephanie James
Sep 13, 2017Copper Contributor
THANK YOU!!!!!!!!!!!!!!!!!!!!!!