Large formula

B

BuckinB

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

Jacob Skaria

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

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

LARGE will return negative numbers.

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

ryguy7272

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

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Possible to Combine reports to's to a single box? 0
INDEX function array causes problem when attempting to use LARGEfunction to sort positive and negati 10
IF Statement accepting only positive values 1
Merging from an Excel file with graphics 1
SUMIF with broken range 10
Autonumber field in Excel that behaves the same as Access 0
using an IF or AND function to get next largest value in list 1
Problem with formula for finding last greater than/less than or equal to value 2

Top