| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Function Macro for Nested IF
I need to create a macro to "break" my statement to get the information i
need. I want to create a macro that will allow me to average data each month as each month in the year goes by. Here is the formula I was attempting: =IF(E10="",D10,IF(F10="",SUM(D10+E10)/2,IF(G10="",SUM(D10:F10)/3,IF(H10="",SUM(D10:G10)/4,IF(I10="",SUM(D10:H10)/5,IF(J10="",SUM(D10:I10)/6,IF(K10="",SUM(D10:J10)/7,IF(L10="",SUM(D10:K10)/8,...." Once I get past the 7th nested IF the formula stops working. So if "D10 = January" what is an example of a function macro that would work? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date Overdue function, Macro, or VBS | Excel Discussion (Misc queries) | |||
| Macro or Function to make text size to suite text Length? | Excel Discussion (Misc queries) | |||
| Record Macro Relative does not work? | Excel Discussion (Misc queries) | |||
| I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
| Macro and If Statement | Excel Discussion (Misc queries) | |||
Threaded Mode
