Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Formula Guidance. Formula need to determine if cell is p
"Lars-Ã…ke Aspelin" wrote: On Fri, 19 Feb 2010 09:49:01 -0800, Matt wrote: Hi, Hopefully someone will be able to provide some guidance. I have been tasked with setting up some spreadsheets at work to application coming into my department and the number of days it takes for us to deal with them. To work this out is easy enough using formula =NETWORKDAYS(B4,E4,$A$119:$A$158) with the numbers involved with the $ referencing bank holidays listed in the spreadsheet and B4 received date and E4 being the completed date. I now need to include some extra lines as I need to be able to monitor written enquiries as well so the headings would read Application Received (AR), Enquiry Received (ER), Completed Date (CD) so that you put the date in either of the first two cells depending on which one needs to be completed. So I now need a new formula that would look at AR determine if a date is in the cell if it isnt populated it looks at ER instead whichever cell is completed it then works out the networkdays by looking at CD. I guess using the same formula listed above. Can this be done, as I have completed everything else and this is just the one thing that is stumping me. If so can someone tell me what the formula would say. I have surprised myself that I was able to do everything else with a lot of hard work and Google searches, this is just the one thing that is stumping me. I hope Ive explained myself well, which will enable someone to advice. Thanking you in advance Matt If AR is in column B and ER is in column C, try to replace B4 with IF(B4<"",B4,C4), like this: =NETWORKDAYS(IF(B4<"",B4,C4),E4,$A$119:$A$158) Hope this helps / Lars-Ã…ke . That works a treat!! Many thanks :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to determine if a cell contains a value or a formula? | Excel Discussion (Misc queries) | |||
how do I determine if a cell is used in a formula | Excel Discussion (Misc queries) | |||
Formula Guidance | Excel Worksheet Functions | |||
How can I determine if a cell has a value (#) or a formula (X*Y)? | Excel Discussion (Misc queries) | |||
What formula do I use in Excel to determine whether one cell fall. | Excel Worksheet Functions |