Join 2 Conditions Q

[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

 

[Per Jessen]

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