Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested if
I have been trying to figure this out for quite a while and can't get
anything to work. Here's what I have. A list of due date, date submitted. I want to show in another column, when something is late or on time. If not submitted yet, and due date is today or beyond, the late/on time indicator can be blank. If blank and due date has passed, show late. If submitted by or before due date, it's on time. Hope someone can help me construct the correct formula. Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested if
One way:
Assume date submitted in column A, due date in column B. C1: =IF(A1="",IF(B1=TODAY(),"","Late"),IF(A1<=B1,"On Time","Late")) In article , mwavra wrote: I have been trying to figure this out for quite a while and can't get anything to work. Here's what I have. A list of due date, date submitted. I want to show in another column, when something is late or on time. If not submitted yet, and due date is today or beyond, the late/on time indicator can be blank. If blank and due date has passed, show late. If submitted by or before due date, it's on time. Hope someone can help me construct the correct formula. Thanks. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested if
Thank you very much!!!! I had one close, but this, of course, is perfect.
"JE McGimpsey" wrote: One way: Assume date submitted in column A, due date in column B. C1: =IF(A1="",IF(B1=TODAY(),"","Late"),IF(A1<=B1,"On Time","Late")) In article , mwavra wrote: I have been trying to figure this out for quite a while and can't get anything to work. Here's what I have. A list of due date, date submitted. I want to show in another column, when something is late or on time. If not submitted yet, and due date is today or beyond, the late/on time indicator can be blank. If blank and due date has passed, show late. If submitted by or before due date, it's on time. Hope someone can help me construct the correct formula. Thanks. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested if
Hi
With Due Date in A1 and Submitted in B2 =IF(AND(B2="",TODAY()-A2<=0),"Waiting", IF(AND(B2="",TODAY()-A20),"Late", IF(AND(B2<"",A2-B2<0),"Late","on time"))) Change "Waiting to "" if you just want to show an empty cell where it is neither Late nor On time -- Regards Roger Govier "mwavra" wrote in message ... I have been trying to figure this out for quite a while and can't get anything to work. Here's what I have. A list of due date, date submitted. I want to show in another column, when something is late or on time. If not submitted yet, and due date is today or beyond, the late/on time indicator can be blank. If blank and due date has passed, show late. If submitted by or before due date, it's on time. Hope someone can help me construct the correct formula. Thanks. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested if
Thank you so much. I especially liked being able to show "waiting" or
"pending." Thanks again. "Roger Govier" wrote: Hi With Due Date in A1 and Submitted in B2 =IF(AND(B2="",TODAY()-A2<=0),"Waiting", IF(AND(B2="",TODAY()-A20),"Late", IF(AND(B2<"",A2-B2<0),"Late","on time"))) Change "Waiting to "" if you just want to show an empty cell where it is neither Late nor On time -- Regards Roger Govier "mwavra" wrote in message ... I have been trying to figure this out for quite a while and can't get anything to work. Here's what I have. A list of due date, date submitted. I want to show in another column, when something is late or on time. If not submitted yet, and due date is today or beyond, the late/on time indicator can be blank. If blank and due date has passed, show late. If submitted by or before due date, it's on time. Hope someone can help me construct the correct formula. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Overcoming Nested IF limits | Excel Discussion (Misc queries) | |||
Nested Sub-Totals in Excel | Excel Discussion (Misc queries) | |||
Nested Subtotals in Excel 2002 | Excel Discussion (Misc queries) | |||
Why are my nested sub-totals are displaying incorrectly? | Excel Discussion (Misc queries) | |||
Nested IF statements | Excel Worksheet Functions |