Excel 2007 IF with AND & OR

[johnhugh]

Hi,

I'm trying to get an IF statement working which uses AND & OR in its conditions.

I want to check whether a number is between a certain range or a specific number.
I can't work out how to combine AND & OR in the same IF statement.

=IF(AND(H11>=5811,H11<=5819,H11=5656,H11=5654),"EBITDA","ITDA")

 

[johnhugh]

That should be it.

=IF(AND(H4>=5811,H4<=5819),"ITDA",IF(OR(H4=5656,H4=5654),"ITDA","EBITDA"))

 

[Deniall]

Or, achieving the same result as johnhugh's formula:
=IF(OR(AND(H4>=5811,H4<=5819),H4=5656,H4=5654),"ITDA","EBITDA")