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

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

Jerry,

Something like:

=IF(AND(B110,B1<20),"Do something",Do something else")

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk

"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

On Mon, 19 Sep 2005 09:51:14 -0700, JerryS
wrote:

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

look at IF, AND, OR

e.g.

=IF(AND(A1value1,A1<value2),"Meets Criteria","")


--ron

=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

JerryS Wrote:
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

This generic formula should work for you.

=IF(AND(A1ONE_NUMBER,A1<SECOND_NUMBER),\"RETURN A VALUE\",\"DO
NOTHING\")

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=468889