Assuming your values are 5 and 50:
=if(and(a15,a1<=50),"one value","another value")
In english: If A1 is greater than 5 and less than or equal to 50...
************
Anne Troy
www.OfficeArticles.com

"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