Hi!
Just taking a guess that the months are listed in A6:L6?
=INDEX(A6:L6,MATCH(MAX(A7:L7),A7:L7,0))
Biff
-----Original Message-----
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),"Feb ruary",IF
(C7MAX(A7:L7),"March",IF(D7MAX(A7:L7),"April",IF (E7MAX
(A7:L7),"May",IF(F7MAX(A7:L7),"June",IF(G7MAX
(A7:L7),"July"))))))&IF(H7MAX(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?
.
|