How to create an IF, TRUE statement for a range?

[lizsunnysideup]

Hello. Was wondering if someone might help me with an If, TRUE statement for a range? I'd like the range to be 0-60. The other thing is that the lower value has to be equal to or greater than 0, and the higher value has to be less than or equal to 60.

 

[Eric W]

Welcome to the forum.

Do you mean that you want to see if a cell's value is in that range? Then try:

=IF(AND(A1>=0,A1<=60),TRUE)

Or do you want to check every value in a range to see if all the values are are between 0 and 60? If so, try:

=IF(COUNTIF(A1:C10,"<0")+COUNTIF(A1:C10,">60")=0,TRUE)

 

[lizsunnysideup]

It was the first one, and it worked! Thanks so much

 

[Eric W]

Glad to help!

 

[Rick Rothstein]

Do you mean that you want to see if a cell's value is in that range? Then try:

=IF(AND(A1>=0,A1<=60),TRUE)

It was the first one, and it worked! Thanks so much

If you are looking for an answer of TRUE or FALSE, you can eliminate the IF function call like this...

=AND(A1>=0,A1<=60)

There is another construction available...

=ABS(A1-30)<=30

but I am guessing you would find the first one's logic easier to follow.