IF statement containing OR

I am trying to use an IF statement that contains OR however, I am not sure
how to us it. I need to have numbers that are between -10.05 and 21.55 be
true and any other numbers be false. How do I set this up using and OR
conjuction?

I think you need an "AND" rather than an "OR", since you want your number to
meet both conditions rather than just one or the other. Try this:

=IF(AND(A1>-10.05,A1<21.55),"true","false")

HTH,
Elkar

"Steph" wrote:

> I am trying to use an IF statement that contains OR however, I am not sure
> how to us it. I need to have numbers that are between -10.05 and 21.55 be
> true and any other numbers be false. How do I set this up using and OR
> conjuction?

=IF(OR(A1<-10.05,A1>22.55),FALSE,TRUE)

Homework?

--
HTH

Sandy
[email protected]
Replace@mailinator with @tiscali.co.uk

"Steph" <[email protected]> wrote in message
news:[email protected]...
>I am trying to use an IF statement that contains OR however, I am not sure
> how to us it. I need to have numbers that are between -10.05 and 21.55 be
> true and any other numbers be false. How do I set this up using and OR
> conjuction?