I need a clever BETWEEN worksheet formula. Assume I have values in A1:A3 and I need to determine if A2 is in between A1 and A3.
Now further assume that there is no defined sort order for this range. I could also have
and it should return TRUE. Currently I’m using
It works fine, but it’s so darn long. Slightly smaller:
I feel like I missing something easy here.
P.S. If you leave a comment with a formula use ampersand-gee-tee-semicolon for greater than and ampersand-ell-tee-semicolon for less than.