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 than 2 (or between 0 and -2). If it is greater than 2 (or less than -2), I would like A2 to display either B2 or D2 depending on which team it favors. In this example, A2 should display "DO NOT PLAY". However, if DE Spread was, say, -8.5, A2 should display "Bengals". If DE Spread was -2.5, A2 should display "Texans". 

 

I've been trying to use the IF function to accomplish this, but I'm in over my head. Is there anything I can do that would remotely achieve what I'm looking for?

Formulas & Functions
Need Help
  • SergeiBaklan's avatar
    SergeiBaklan
    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)
)

2 Replies

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