Forum Discussion

Stephanie James's avatar
Stephanie James
Copper Contributor
Sep 13, 2017
Solved

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...
  • SergeiBaklan's avatar
    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)
    )