Help making this an OR statement

[easybpw]

Hello,

Thanks in advance for your help.

I realize the formula below may have other issues that could be corrected and I appreciate any tips or suggestions given. But my main problem is I want this to be an OR statement and not sum the two together. I'll try and show it below.

=IF(AND(VLOOKUP($A17,'Team Def'!$A$4:$B$35,2,FALSE)>0,VLOOKUP($A17,'Team Def'!$A$4:$B$35,2,FALSE)<11),IF(AND($E18>3,$E18<4),1,0),2)+IF(AND(VLOOKUP($A17,'Team Def'!$A$4:$B$35,2,FALSE)>0,VLOOKUP($A17,'Team Def'!$A$4:$B$35,2,FALSE)<11),IF(AND($E18>2,$E18<3),1,0),1)

I've tried the things I know to do but am not having any luck.

Thanks again!

Bill

 

[Special-K99]

Try

=IF(AND(VLOOKUP($A17,'Team Def'!$A$4:$B$35,2,FALSE)>0,VLOOKUP($A17,'Team Def'!$A$4:$B$35,2,FALSE)<11),IF(OR(AND($E18>3,$E18<4),AND($E18>2,$E18<3)),1,0),3)