INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • 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.

Jobs

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:
thread770-319278: Problem with IF statement

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

winky smile

http://julianh72.blogspot.com

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.

http://julianh72.blogspot.com

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 winky smile )

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.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources


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:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close