Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding columns
A B C D E F G H
1 - 07/08/04 07/12/04 5 07/12/04 07/30/04 19 23 2 - 05/21/04 05/25/04 5 5 3 - 05/26/04 06/24/04 30 30 4 - -1 5 - 07/14/04 07/26/04 13 07/26/04 07/21/04 1 13 =IF(M7=O7,N(Q7)+N(N7)-1,N(Q7)+N(N7)) Can anyone help - I am using the formula above to determine the number of days a person in in a Nursing Home in column a & B -- and number of days in a Skilled Nursing Facility in E & F - my formula needed to tell if C & E were same day to not count them twice and if A & B are same day to count it as one day -- the problem I am having is in line 4 in above example - if there is no information for the month - it puts a -1 in column H - I need to have a 0 if it is blank or I see it as they owe me one day of costs. Can you tell me how to fix it? I am not good at computer language -- Thanks so much and have a great day !! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding Columns, Then deleting old columns | Excel Discussion (Misc queries) | |||
adding columns | Excel Worksheet Functions | |||
Adding from several columns if ... | Excel Worksheet Functions | |||
Adding Columns | Excel Discussion (Misc queries) | |||
Adding columns | Excel Programming |