IF, between two numbers
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
|