| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| How can I print out a list of statistical functions in Excel (I d. | Excel Worksheet Functions | |||
| How do I give permission for certain functions in excel in locked. | Excel Worksheet Functions | |||
| How do I get to master Excel functions and formulas? | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Threaded Mode
