Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
hi,
i am looking at a report that i am trying to interpret... the following formula is in the =IF(ISERROR((INDEX(Data!$A$398:$HD$460, MATCH(Z11,Data!$A$398:$A$460,FALSE), MATCH('Current Month'!$C$2,Data!$A$398:$HD$398,FALSE))+INDEX(Data !$A$462:$HD$524, MATCH(Z11,Data!$A$462:$A$524,FALSE),MATCH('Current Month'!$C$2,Data!$A$462:$HD$462,FALSE)))/INDEX(Data!$A$526:$HD$588,MATCH(Z11,Data!$A$526:$A $588,FALSE),MATCH('Current Month'!$C$2,Data!$A$526:$HD$526,FALSE))),0,(INDEX( Data!$A$398:$HD$460,MATCH(Z11,Data!$A$398:$A$460,F ALSE),MATCH('Current Month'!$C$2,Data!$A$398:$HD$398,FALSE))+INDEX(Data !$A$462:$HD$524,MATCH(Z11,Data!$A$462:$A$524,FALSE ),MATCH('Current Month'!$C$2,Data!$A$462:$HD$462,FALSE)))/INDEX(Data!$A$526:$HD$588,MATCH(Z11,Data!$A$526:$A $588,FALSE),MATCH('Current Month'!$C$2,Data!$A$526:$HD$526,FALSE))) i cant seem to interpret it. help! thanks in advance, geebee |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Index from TM | Excel Worksheet Functions | |||
PivotTable.columnfields(index) vs Pivotcell.columnitem(index) | Excel Programming | |||
Chart axes color index vs font color index | Charts and Charting in Excel | |||
How do I pull the col. index value as well as row index value | Excel Discussion (Misc queries) | |||
Using INDEX twice?? | Excel Worksheet Functions |