If X<=2 and X>=-2?

M

Mike

Hi everyone,

I don't want to say "if X<=2 and X>=-2", instead one thing that would combine both conditions.

Any way?

Mike
 
C

Claus Busch

Hi Mike,

Am Tue, 7 Jan 2014 12:15:32 -0800 (PST) schrieb Mike:
I don't want to say "if X<=2 and X>=-2", instead one thing that would combine both conditions.
Click to expand...

try:
=ABS(A1)<=2


Regards
Claus B.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extract Text in braquet and list of terms from 2 Docs 3
Sorting and filtering text 0
Automatically sending multiple parts of text from one word doc to another - is possible. 0
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Word Template and Normal Style 1
Section and Page numbering 0
Template with fields and premade texts.. 0
Auto Merge text from multiple sources 0

Top