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? |
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? |
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? . |
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? |
All times are GMT +1. The time now is 11:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com