If / Then Question

[cal]

Another one...

I would like a formula that will return true if a value
is between or equal to -10 to -1

Thanks again in advance.

 

[Art]

If your value is in B1, try: =AND(B1>=-10,B1<=-1)

Art

 

[JE McGimpsey]

One way:

=ABS(A1+5.5)<=4.5

 

[hgrove]

cal wrote...
...

I would like a formula that will return true if a value is between
or equal to -10 to -1

Adapt the responses you've already received.

=AND(X>=-10,x<=-1)

or somewhat trickier

=ABS(x+5.5)<=4.