Thread: Adding the resulting intersection to an If statement.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
M.A.Tyler M.A.Tyler is offline
external usenet poster
  
Posts: 100
Default 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.
Reply With QuoteReply With Quote