Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Networkdays with cells yet to be entered (creating nested if)
Here's what I have:
D4 = Date Companint Received E4 = Date Complaint Filed F4 = Networkdays(D4,E4)-1 This works great for what I need, provided that the information in cells D# and E# are filled out. This sheet that I have is new and a lot of the cells have yet to be filled in. The cells where D and E are both blank, F shows -1. The cells where D is blank and E is valued show a value around 2800 The cells where D is valued and E is blank show a value of around -2800 My question is how can I change the networkdays formula to also meet the below criteria. I know it will be a nested if, but I'm weak with those. If D4 = blank and E4 = nonblank - "ENTER DATE COMPLAINT RECEIVED" If E4 = blank and D4 = nonblank - "ENTER FC FILED DATE" If D4 & E4 = blank - "FILL IN DATES" If D4 & E4 are both valued - Networkdays(D4,E4)-1 Thanks in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Networkdays with cells yet to be entered (creating nested if)
=IF(E4="",IF(D4="","FILL IN DATES","ENTER FC FILED DATE"),if(d4="","ENTER
DATE COMPLAINT RECEIVED",Networkdays(D4,E4)-1) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Jeremy" <jeremiah.a.reynolds @ gmail.com wrote in message ... Here's what I have: D4 = Date Companint Received E4 = Date Complaint Filed F4 = Networkdays(D4,E4)-1 This works great for what I need, provided that the information in cells D# and E# are filled out. This sheet that I have is new and a lot of the cells have yet to be filled in. The cells where D and E are both blank, F shows -1. The cells where D is blank and E is valued show a value around 2800 The cells where D is valued and E is blank show a value of around -2800 My question is how can I change the networkdays formula to also meet the below criteria. I know it will be a nested if, but I'm weak with those. If D4 = blank and E4 = nonblank - "ENTER DATE COMPLAINT RECEIVED" If E4 = blank and D4 = nonblank - "ENTER FC FILED DATE" If D4 & E4 = blank - "FILL IN DATES" If D4 & E4 are both valued - Networkdays(D4,E4)-1 Thanks in advance |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Networkdays with cells yet to be entered (creating nested if)
Helpful again, thanks Bob.
"Bob Phillips" wrote: =IF(E4="",IF(D4="","FILL IN DATES","ENTER FC FILED DATE"),if(d4="","ENTER DATE COMPLAINT RECEIVED",Networkdays(D4,E4)-1) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Jeremy" <jeremiah.a.reynolds @ gmail.com wrote in message ... Here's what I have: D4 = Date Companint Received E4 = Date Complaint Filed F4 = Networkdays(D4,E4)-1 This works great for what I need, provided that the information in cells D# and E# are filled out. This sheet that I have is new and a lot of the cells have yet to be filled in. The cells where D and E are both blank, F shows -1. The cells where D is blank and E is valued show a value around 2800 The cells where D is valued and E is blank show a value of around -2800 My question is how can I change the networkdays formula to also meet the below criteria. I know it will be a nested if, but I'm weak with those. If D4 = blank and E4 = nonblank - "ENTER DATE COMPLAINT RECEIVED" If E4 = blank and D4 = nonblank - "ENTER FC FILED DATE" If D4 & E4 = blank - "FILL IN DATES" If D4 & E4 are both valued - Networkdays(D4,E4)-1 Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating Nested If Fuctions | Excel Worksheet Functions | |||
Creating Nested Functions | Excel Discussion (Misc queries) | |||
Creating Nested Functions | Excel Worksheet Functions | |||
Creating a nested COUNTIF???? | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |