Multiple IF function

[Stephanie James]

 

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?

[#2 · Accepted solution]

Hi Stephanie,

Do you mean somehing like this?

=IF(ABS(D14-D15)<2,
	"DO NOT PLAY",
	IF(ABS(D15)>ABS(D14),D2,B2)
)

[#3]

THANK YOU!!!!!!!!!!!!!!!!!!!!!!