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","F ebruary","March",
"April",May","June","July","August","September","O ctober","November",
"December")



In article ,
DMB wrote:

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(A7MAX(B7:L7),"January",IF(B7MAX(A7:L7),"Febr uary",IF(C7MAX(A7:L7),"Marc
h",IF(D7MAX(A7:L7),"April",IF(E7MAX(A7:L7),"May" ,IF(F7MAX(A7:L7),"June",IF(
G7MAX(A7:L7),"July"))))))&IF(H7MAX(A7:L7),"Augus t")).
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?