Equal to, Greater than, Less than 1

[AELLC]

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 ?

 

[electricpete]

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

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

Yes.

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)' ?

 

[IDS]

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

Correct

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.

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/

 

[IDS]

Electricpete's answer to Part 1 is correcter than mine

Doug Jenkins
Interactive Design Services

http://newtonexcelbach.wordpress.com/

 

[jhardy1]

@electricpete:

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

2B ∨ !2B

;-)

http://julianh72.blogspot.com

 

[IDS]

jhardy1 -

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



Doug Jenkins
Interactive Design Services

http://newtonexcelbach.wordpress.com/

 

[jhardy1]

@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

 

[AELLC]

Thanks ElectricPete

 

[electricpete]

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)' ?