B BuckinB Nov 3, 2009 #1 In Excel 2007 How do I get the formula: =large(a1:a9,6) to return negative numbers, I only get positive.
In Excel 2007 How do I get the formula: =large(a1:a9,6) to return negative numbers, I only get positive.
J Jacob Skaria Nov 3, 2009 #2 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
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
C CellShocked Nov 3, 2009 #3 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?
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?
T T. Valko Nov 3, 2009 #4 LARGE will return negative numbers. Maybe post a sample of your data and tell us what result you expect.
LARGE will return negative numbers. Maybe post a sample of your data and tell us what result you expect.
R ryguy7272 Nov 3, 2009 #5 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---
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---
D David Biddulph Nov 3, 2009 #6 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.
C CellShocked Nov 3, 2009 #7 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.
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.
