J
JerryS
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
that one value and less than another. Any suggestions? Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
BenjieLop
JerryS said: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.
A
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
=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
S
Sandy Mann
Jerry,
Something like:
=IF(AND(B1>10,B1<20),"Do something",Do something else")
--
HTH
Sandy
[email protected]
Replace@mailinator with @tiscali.co.uk
Something like:
=IF(AND(B1>10,B1<20),"Do something",Do something else")
--
HTH
Sandy
[email protected]
Replace@mailinator with @tiscali.co.uk
R
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
B
Bob Phillips
=IF(AND(A2>num1,A2<num2)return_value,"")