Join 2 Conditions Q

  • Thread starter Thread starter Seanie
  • Start date Start date
S

Seanie

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
 
Try this:

=IF(AND(NOW()-TODAY()<(1140/1440),(1440/1440)),INDEX(AW1:AW7,MATCH(TODAY(),AV1:AV7)),INDEX(AW1:AW7,MATCH(TODAY()-1,AV1:AV7,0)))

Hint: Place the cursor in the if statement at the formula line and click on
the equal sign left to the formula.

Regards,
Per
 
Back
Top