=IF(AND(A2num1,A2<num2)return_value,"")

--
HTH

Bob Phillips

"JerryS" wrote in message
...
I'm trying to create a formula that returns a value if a number is greater
that one value and less than another. Any suggestions? Thanks
--
JerryS