If / Then Question

  • Thread starter Thread starter cal
  • Start date Start date
C

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.
 
cal wrote...
...
I would like a formula that will return true if a value is between
or equal to -10 to -1
Click to expand...

Adapt the responses you've already received.

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

or somewhat trickier

=ABS(x+5.5)<=4.
 
Back
Top