Thread: Join 2 Conditions Q
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Seanie Seanie is offline
external usenet poster
  
Posts: 202
Default Join 2 Conditions Q
IF(AND(NOW()-TODAY()<(1140/1440),(1440/1440)),INDEX(AW1:AW7,MATCH(TODAY
(),AV1:AV7))

If NOT then

INDEX(AW1:AW7,MATCH(TODAY()-1,AV1:AV7,0))

I'm getting totally confused with ()'s
Reply With QuoteReply With Quote