How can I nest more than seven functions in MS Excel?

D

DMB

I need to know how to nest more than seven functions in MS Excel. I am trying
to do a spreadsheet with highest and lowest dollar figures for the 12 months
of the year but it only lets me nest up to 7 months. For example, I'm trying
to complete the formula:
=IF(A7>MAX(B7:L7),"January",IF(B7>MAX(A7:L7),"February",IF(C7>MAX(A7:L7),"March",IF(D7>MAX(A7:L7),"April",IF(E7>MAX(A7:L7),"May",IF(F7>MAX(A7:L7),"June",IF(G7>MAX(A7:L7),"July"))))))&IF(H7>MAX(A7:L7),"August")).
I need to get the rest of the months in so I can have the spreadsheet set up
to automatically display the months that have the highest and lowest amounts.
Can someone help?
 
J

JE McGimpsey

Instead, try something like:

=TEXT(DATE(2000,MATCH(MAX(A7:L7),A7:L7,FALSE),1),"mmmm")

or

=CHOOSE(MATCH(MAX(A7:L7),A7:L7,FALSE),"January","February","March",
"April",May","June","July","August","September","October","November",
"December")
 
B

Biff

Hi!

Just taking a guess that the months are listed in A6:L6?

=INDEX(A6:L6,MATCH(MAX(A7:L7),A7:L7,0))

Biff
 
K

K.S.Warrier

hi,
Here as the conditions are mutually exclusive,I think you may try this.
=If(A7>Max(B7:L7),"January","")&if(B7>Max(A7:L7),"February","")&.....
This is done by splitting the conditions with if functions and cmbining them
with "&" ,so that more than 7 functions can be nested.

Thanking you,
K.S.Warrier
 

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

Top