Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 8th 05, 05:45 AM
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  
Old January 8th 05, 06:00 AM
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  
Old January 8th 05, 06:14 AM
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  
Old January 9th 05, 04:47 PM
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
How can I print out a list of statistical functions in Excel (I d. pegberger Excel Worksheet Functions 1 January 5th 05 10:12 PM
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 1 January 5th 05 08:36 AM
How do I give permission for certain functions in excel in locked. tradinoncoffee Excel Worksheet Functions 1 January 2nd 05 06:52 PM
How do I get to master Excel functions and formulas? Basabjit Chowdhury Excel Worksheet Functions 3 December 29th 04 08:15 PM
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. Robert AS Excel Worksheet Functions 4 December 2nd 04 10:49 AM


All times are GMT +1. The time now is 12:00 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017