Excel function equivalent

[ruggedbill]

Is there a logical function equivalent to between? If x is between Y and Z, then true

[#2]

Hi

=MEDIAN(X,Y,Z)=X