Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
DMB
 
Posts: n/a
Default 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?
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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?

  #3   Report Post  
Biff
 
Posts: n/a
Default

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?
.

  #4   Report Post  
K.S.Warrier
 
Posts: n/a
Default

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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
How can I print out a list of statistical functions in Excel (I d. pegberger Excel Worksheet Functions 1 January 5th 05 11:12 PM
How do I give permission for certain functions in excel in locked. tradinoncoffee Excel Worksheet Functions 1 January 2nd 05 07:52 PM
How do I get to master Excel functions and formulas? Basabjit Chowdhury Excel Worksheet Functions 3 December 29th 04 09:15 PM
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. Robert AS Excel Worksheet Functions 4 December 2nd 04 11:49 AM


All times are GMT +1. The time now is 08:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"