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

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.

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.

On Mon, 2 Nov 2009 21:00:01 -0800, BuckinB
wrote:

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


You forgot to include a bit of sample data.

Give a sample list of number to fill the array, and what you expect to
see as an answer.

What cell are you 'running' the formula in?

LARGE will return negative numbers.

Maybe post a sample of your data and tell us what result you expect.

--
Biff
Microsoft Excel MVP


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

LARGE in that formula will return a negative number if it is the 6th
largest. If you want the 6th smallest, change LARGE to SMALL.
--
David Biddulph

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

On Tue, 3 Nov 2009 12:15:13 -0000, "David Biddulph" <groups [at]
biddulph.org.uk wrote:

LARGE in that formula will return a negative number if it is the 6th
largest. If you want the 6th smallest, change LARGE to SMALL.


Also -5 is LARGEr than -10 is.

I get negative values when appropriate. What does your data look like?
--
Daryl S


"BuckinB" wrote:

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