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 ?
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
thread770-319278: Problem with IF statement
Yes.
Yes it makes a difference. If you try it you’ll see => causes an error.
=====================================
(2B)+(2B)' ?
RE: Equal to, Greater than, Less than
Correct
Yes, although you could write it =AND(3.00<=B22, B22<=3.13) if you want.
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
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Equal to, Greater than, Less than
In the context of this discussion - shouldn't your sig actually read:
2B ∨ !2B
http://julianh72.blogspot.com
RE: Equal to, Greater than, Less than
Surely: =OR(2B = TRUE, 2B = FALSE)
:)
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Equal to, Greater than, Less than
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
RE: Equal to, Greater than, Less than
Universal truth... hadn't thought of that. I didn't realize how profound my sig was until you guys started in.
=====================================
(2B)+(2B)' ?