IF, between two numbers

[ADK]

How would I use and if statement based on between two numbers??

Example---

For cell A6: IF A5 is between .99 and 5, 1, 0

A5 = .25 ....so A6 is 0

A5 = 1 ......so A6 is 1

A5 = 4 .....so A6 is 1

A5 = 5 ......so A6 is 0

A5 = 6 ......so A6 is 0

----------------------------------

ALSO, have one: IF A5 is equal to 1 or between 1 and 5, but not equal or
more than 5?

Thanks

 

[Guest]

Several ways, but try this one
=IF(A6>=1,IF(A6<5,1,0),0)

 

[Bob Phillips]

=--AND(A5>0.99,A5<5)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)