If / Then Question

cal · Aug 5, 2004

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 · Aug 5, 2004

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

Art

JE McGimpsey · Aug 5, 2004

One way:

=ABS(A1+5.5)<=4.5

hgrove · Aug 5, 2004

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.