Hi,

It isn't doing that. Consider the numbers below In a1 to a17

=MEDIAN(A1:A16) Returns 8.5

=MEDIAN(A1:A16,22) Returns 9

=MEDIAN(A1:A17) Returns 9

All your doing by adding ,1 to the median arguments is adding an additional
number for it to calculate.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
22

Mike

"Bony Pony" wrote:

Am I going crazy?

Create 16 values so that the formula
=median(a1:a16)

does not return the value of an actual cell you have typed.

Now use
=median(a1:a16,1)

and it gives you the cell in your range that is closest (lower range) to the
median!

Can anyone explain this?

Regards,
Bony