Random number generators often state they generate a number between 0 and 1.
They do not mean =0 and <= 1. The do not mean 0 and < 1. They mean = 0
and <1. Go figure!

"dalymjl" wrote in message
...

I have a number stored in Cell A1. I want to test whether or not that
number falls between 153 and 381 and to return the value TRUE or FALSE
in Cell B1. I've tried using the IF function and the AND function but
it does not like the expression "A1 between 153 and 381". Can anyone
help please?

MJD




--
dalymjl