Another one:

=A1=MEDIAN(A1:C1)

--
Biff
Microsoft Excel MVP


"Arlen" wrote in message
...
How do you test if a number is equal to or BETWEEN two other numbers,
rather
than greater than or equal to the smallest and less than or equal to the
biggest.

Reason being, the smaller number and the larger number may swap cell
addresses at times.

Thanks, all.

Arlen