Often people mean between two numbers to include the two numbers.
So if between means including the 153 and the 381 the formula becomes
=IF(AND(A1=153),(A1<=381))


"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