Large formula

  • Thread starter Thread starter BuckinB
  • Start date Start date
B

BuckinB

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
 
In Excel 2007
How do I get the formula: =large(a1:a9,6) to return negative numbers, I
only get positive.
Click to expand...


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.
 
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---
 
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.
 
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.
Click to expand...


Also -5 is LARGEr than -10 is.
 
Back
Top