Combine AND and OR in IF statement

[eboerma]

I need to combine AND and OR in Excel IF statement and I'm not able to get the formula to return the correct answer. Any help would be greatly appreciated!!

Example:
If A1 is greater than plus or minus $50,000 AND A2 is greater than plus or minus 10%

=IF(AND(OR(BG5>50000,BH5>0.1),OR(BG5<-50000,BG5<-0.1)),"Over","Under")

 

[Sam_ExcelVault]

From your description then I think you are looking to test 2 overall conditions:

1. Value A is greater than 50000 OR less than -50000
2. Value B is greater then 10% OR less than -10%

If both of these conditions evaluate to true then return "Over" else return "Under". If that's the case, you're pretty close; try this instead:

=IF(AND(OR(BG5>50000,BG5<-50000),OR(BH5>0.1,BH5<-0.1)),"Over","Under")

 

[jtakw]

Hi,

I think you just have your AND/OR mixed up:

=IF(OR(AND(BG5>50000,BH5>0.1),AND(BG5<-50000,BH5<-0.1)),"Over","Under")