| 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. |
| 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 | |||
Threaded Mode
