Jacob is correct. Not sure where you're going BuckingB, but maybe this is
what you want:
=-LARGE(A1:A13,6)

Long shot...

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Jacob Skaria" wrote:

Large returns negative..Try the same formula with the below data in
A1:A9...to see that it returns -6 which is the 6th largest of the lot.

-1
-2
-3
-4
-5
-6
-7
-8
-9

If this post helps click Yes
---------------
Jacob Skaria


"BuckinB" wrote:

In Excel 2007
How do I get the formula: =large(a1:a9,6) to return negative numbers, I
only get positive.