| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A somewhat complex (to me at least) Nested IF issue
Hi everyone,
I'm working on a report that looks like this E F G H I Request Date Request Time Dispatch Date Dispatch Time Delay 6 7 8 9 10 The column headings I guess are self explanatory. The problem is with the Delay column. The formula works somewhat like this. If the Request Time is before 3:30 PM on a day the item should be dispatched on the same day. If it is after 3:30 PM, then the dispatch should be done by 11:00 AM the next working day. We don't work on saturdays and sundays. The delay needs to be calculated in days. Can someone please help me out here? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Complex Index Match Help (or at least complex to me) | Excel Discussion (Misc queries) | |||
| Complex Vlookup and List Validation and Nested IF statements | Excel Worksheet Functions | |||
| Complex data referencing - too many for nested IF's | Excel Worksheet Functions | |||
| HELP? nested, complex, vlookup? The impossible! | Excel Worksheet Functions | |||
| Help with complex index array issue | Excel Worksheet Functions | |||
Linear Mode
