IF formula

[Guest]

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

 

[BenjieLop]

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

This generic formula should work for you.

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

Regards.

 

[Anne Troy]

Assuming your values are 5 and 50:
=if(and(a1>5,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

 

[Sandy Mann]

Jerry,

Something like:

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

--
HTH

Sandy
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk

 

[Ron Rosenfeld]

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(A1>value1,A1<value2),"Meets Criteria","")


--ron

 

[Bob Phillips]

=IF(AND(A2>num1,A2<num2)return_value,"")