Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding the resulting intersection to an If statement.
=IF(Sheet1!AQ81,INT(Sheet1!W8/100)*60+MOD(Sheet1!W8,100)+(Sheet1!AR8/10)+INDEX('Adjust
Pts'!$C$8:$Q$651,MATCH(Pace!J4,'Adjust Pts'!$C$6:$Q$6,0),MATCH(Pace!L4,'Adjust Pts'!$B$8:$B$651,0)),INT(Sheet1!W8/100)*60+MOD(Sheet1!W8,100))+INDEX('Adjust Pts'!$C$8:$Q$651,MATCH(Pace!J4,'Adjust Pts'!$C$6:$Q$6,0),MATCH(Pace!L4,'Adjust Pts'!$B$8:$B$651,0)) Is it possible to add the result of an Index, Match, Match to an If statement? The above formula gives me a #Value! error. I could do this in seperate columns, but thought this might work. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding the resulting intersection to an If statement.
The formula is constructed of an IF() function summed to an INDEX() function:
=IF() + INDEX() The above IF() function also contains a nested INDEX() function: =IF(Sheet1!AQ81,INT()*60+MOD()+(Sheet1!AR8/10)+INDEX(),INT(Sheet1!W8/100)*60+MOD()) From Help, the syntax of the INDEX function is: INDEX(array, row_num, column_num) Your function appears to have the row_num and column_num arguments reversed. For example: INDEX('Adjust Pts'!$C$8:$Q$651,MATCH(Pace!J4,'Adjust Pts'!$C$6:$Q$6,0),MATCH(Pace!L4,'Adjust Pts'!$B$8:$B$651,0)) Should be: INDEX('Adjust Pts'!$C$8:$Q$651,MATCH(Pace!L4,'Adjust Pts'!$B$8:$B$651,0),MATCH(Pace!J4,'Adjust Pts'!$C$6:$Q$6,0)) If I'm correct then the above INDEX() function by itself should return the #REF! error code. Regards, Greg "M.A.Tyler" wrote: =IF(Sheet1!AQ81,INT(Sheet1!W8/100)*60+MOD(Sheet1!W8,100)+(Sheet1!AR8/10)+INDEX('Adjust Pts'!$C$8:$Q$651,MATCH(Pace!J4,'Adjust Pts'!$C$6:$Q$6,0),MATCH(Pace!L4,'Adjust Pts'!$B$8:$B$651,0)),INT(Sheet1!W8/100)*60+MOD(Sheet1!W8,100))+INDEX('Adjust Pts'!$C$8:$Q$651,MATCH(Pace!J4,'Adjust Pts'!$C$6:$Q$6,0),MATCH(Pace!L4,'Adjust Pts'!$B$8:$B$651,0)) Is it possible to add the result of an Index, Match, Match to an If statement? The above formula gives me a #Value! error. I could do this in seperate columns, but thought this might work. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding A Not(IsBlank) To IF Statement(help) | Excel Worksheet Functions | |||
Finding a match and adding to the statement | Excel Discussion (Misc queries) | |||
Adding an AND Statement to COUNTIF | Excel Worksheet Functions | |||
when adding cells resulting from tax calulations they do not equa. | Excel Discussion (Misc queries) | |||
adding if statement results | Excel Worksheet Functions |