If Function

[agpaco]

I need to use more then 7 If function but the Excel don't let me. What can I do?

 

[cmart02]

You can concatenate the IF functions on the false argument. That is, close
the first IF and then use "&" to start a new IF. This will cause if
concatenated IF to be joined into the false clause.

 

[JE McGimpsey]

Nested functions are limited to 7 nested levels

Situations with more than 7 IFs can almost always be better handled by a
Lookup, or a calculation. What are you trying to do?

Alternatively, you might be able to use the technique here:

http://cpearson.com/excel/nested.htm

 

[agpaco]

Thanks

"cmart02" escreveu:

 

[JE McGimpsey]

have you looked at the RANK function?

 

[agpaco]

Yes, but with this function I can't obtain something like this:

25.629.200 € 6º
24.664.500 € 7º
7.500.000 €
4.194.000 €
4.592.000 €
11.528.000 €
53.720.000 € 5º
78.759.000 € 2º
64.333.500 € 4º
73.821.000 € 3º
118.344.000 € 1º

But I need more than the 7º. It's the function that search for the, for
example, 10 high values in the list and give me 1....10.


"JE McGimpsey" escreveu:

 

[JE McGimpsey]

Assuming your 1st column is numbers rather than text, this will
reproduce your table, returning the rank for the 10 highest values in
rank order (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):

=IF(RANK(A1:A11,A1:A11)<=10,RANK(A1:A11,A1:A11),"")

If instead you want the 10 highest values themselves, array-enter this
into, say, C1:C10:

=LARGE(A1:A11,ROW(INDIRECT("1:10")))

Which will return:

118.344.000
78.759.000
73.821.000
64.333.500
53.720.000
25.629.200
24.664.500
11.528.000
7.500.000
4.592.000

 

[agpaco]

Yes! That's exactly what I want. Thanks very much for your help.

"JE McGimpsey" escreveu:

 

[paulbh2]

The link you provided did the job for me. Thanks.