range of values in IF

[pedroc]

I would like excel to return a result for any values that fall outside of a range (19-59) - what's the easiest way to do this using an IF function?

Cheers

pedroc

 

[kpark91]

using comparisons like any other if statements and using AND operator (search it up)
< 19? > 59??

 

[T. Valko]

I would like excel to return a result for any values that fall outside of a range (19-59) - what's the easiest way to do this using an IF function?

Cheers

pedroc

What result?

Maybe something like this...

=IF(OR(A2<19,A2>59),"Outside","OK")

 

[kpark91]

Ah oops.I meant to say OR istead of AND

 

[Jonmo1]

Are you going to be doing multiple ranges with different results?

Like
If between 0 and 10 Then x
If between 11 and 20 Then y
If between 21 and 30 Then z

??

If so, a lookup is much more appropriate than IF's.