Have a look in HELP index for AND . Then mix with an IF function.
=and(if
--
Don Guillett
SalesAid Software

"esslingerdav" wrote in message
...
Is it possible to do a logical test on a cell that will determine whether
the
number falls within a range of numbers then return a yes or no function?