×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Are you an
Engineering professional?
Join Eng-Tips Forums!
• Talk With Other Members
• Be Notified Of Responses
• Keyword Search
Favorite Forums
• Automated Signatures
• Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

#### Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

# Equal to, Greater than, Less than

## Equal to, Greater than, Less than

(OP)
In Excel, this is not valid, correct?
3.00<=B22<=3.13

Would this be necessary and correct?
AND(B22>=3.00,B22<=3.13)

Does the location of equal sign make a difference?

i.e., B22>=3.00 versus B22=>3.00 ?

### RE: Equal to, Greater than, Less than

#### Quote:

In Excel, this is not valid, correct?
3.00<=B22<=3.13
It is actually a “valid” expression in the sense that it causes no syntax error, but I would definitely stay away from it. One of the comparisons is done first and then the logical result (true/false) is compared with the other giving results probably much different than you intended. Long thread on exactly this subject here:

#### Quote:

Would this be necessary and correct?
AND(B22>=3.00,B22<=3.13)
Yes.

#### Quote:

Does the location of equal sign make a difference?
i.e., B22>=3.00 versus B22=>3.00 ?
Yes it makes a difference. If you try it you’ll see => causes an error.

=====================================
(2B)+(2B)' ?

### RE: Equal to, Greater than, Less than

#### Quote:

In Excel, this is not valid, correct?
3.00<=B22<=3.13

Correct

#### Quote:

Would this be necessary and correct?
AND(B22>=3.00,B22<=3.13)

Yes, although you could write it =AND(3.00<=B22, B22<=3.13) if you want.

#### Quote:

Does the location of equal sign make a difference?

i.e., B22>=3.00 versus B22=>3.00 ?

Yes, => and =< are not valid operators, although Excel will helpfully suggest you put them round the right way if you try to use them.

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/

### RE: Equal to, Greater than, Less than

Electricpete's answer to Part 1 is correcter than mine :)

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/

### RE: Equal to, Greater than, Less than

@electricpete:

In the context of this discussion - shouldn't your sig actually read:

2B ∨ !2B

### RE: Equal to, Greater than, Less than

jhardy1 -

Surely: =OR(2B = TRUE, 2B = FALSE)

:)

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/

### RE: Equal to, Greater than, Less than

@IDS:
I guess Shakespeare didn't use Excel - your suggested formula yields an error message (incorrect cell address syntax). The best I can come up with is:

=OR(B2,NOT(B2))

Interestingly, this yields "TRUE" for all values of B2 (both numeric and logical). I guess this proves that we can all find a universal truth in the works of Shakespeare.

### RE: Equal to, Greater than, Less than

(OP)
Thanks ElectricPete

### RE: Equal to, Greater than, Less than

No problem - this was an easy one by the standards of this forum (lots of tough questions and smart answerers... I just got here first by three minutes to win the coveted lps )

Universal truth... hadn't thought of that. I didn't realize how profound my sig was until you guys started in.

=====================================
(2B)+(2B)' ?

#### Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

#### Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Close Box

# Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

• Talk To Other Members
• Notification Of Responses To Questions
• Favorite Forums One Click Access
• Keyword Search Of All Posts, And More...

Register now while it's still free!