The tests given by ikegami here are not quite equivalent to your OPed test if the numbers are not integers:
I've already said as much in my post.
In reply to Re^2: IF condition with a range
by ikegami
in thread IF condition with a range
by Anonymous Monk
| For: | Use: | ||
| & | & | ||
| < | < | ||
| > | > | ||
| [ | [ | ||
| ] | ] |