ExcelBanter - Join 2 Conditions Q

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Join 2 Conditions Q (https://www.excelbanter.com/excel-programming/424170-join-2-conditions-q.html)

Seanie

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

Per Jessen

Join 2 Conditions Q

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

"Seanie" skrev i meddelelsen
...
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

All times are GMT +1. The time now is 09:45 AM.