Remember Me?

 DMB Posts: n/a How can I nest more than seven functions in MS Excel?

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),"March",IF(D7MAX(A7:L7),"A pril",IF(E7MAX(A7:L7),"May",IF(F7MAX(A7:L7),"Jun e",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?

 JE McGimpsey Posts: n/a =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?

 Biff Posts: n/a 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

to automatically display the months that have the highest

and lowest amounts.
Can someone help?
.

 K.S.Warrier Posts: n/a hi,
Here as the conditions are mutually exclusive,I think you may try this.
=If(A7Max(B7:L7),"January","")&if(B7Max(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

"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),"March",IF(D7MAX(A7:L7),"A pril",IF(E7MAX(A7:L7),"May",IF(F7MAX(A7:L7),"Jun e",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?

 Thread Tools Search this Thread Show Printable Version Search this Thread: Advanced Search Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On Similar Threads Thread Thread Starter Forum Replies Last Post pegberger Excel Worksheet Functions 1 January 5th 05 10:12 PM Richard Excel Discussion (Misc queries) 1 January 5th 05 08:36 AM tradinoncoffee Excel Worksheet Functions 1 January 2nd 05 06:52 PM Basabjit Chowdhury Excel Worksheet Functions 3 December 29th 04 08:15 PM Robert AS Excel Worksheet Functions 4 December 2nd 04 10:49 AM

All times are GMT +1. The time now is 01:20 PM. Copyright ©2004-2021 ExcelBanter.