=IF(A1=20,IF(A1<=40,"In Range","Out of Range"))

Just to add on a little to John's suggestion ..
think you could also try something like:
=IF(A1="","",IF(AND(A1=20,A1<=40),"In Range","Out of Range"))
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----