| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Join tables like inner join in Access | Excel Discussion (Misc queries) | |||
| SQL + INNER JOIN + ADO | Excel Programming | |||
| Countif Conditions - Use of conditions that vary by cell value | Excel Discussion (Misc queries) | |||
| shade cells based on conditions - i have more than 3 conditions | Excel Worksheet Functions | |||
Linear Mode
