K
Katie
Subject: Adding columns
From: "Katie" <[email protected]>
Sent: 9/2/2004 8:43:00 AM
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 !!
I have since tried =IF(COUNTA(N7,M7,O7,Q7)=0,0,IF(M&-O7,N
(Q7)+N(N7)-1,N(Q7)+N(N7))) now I get a FALSE in my box -
is there someone out there who can help?
From: "Katie" <[email protected]>
Sent: 9/2/2004 8:43:00 AM
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 !!
I have since tried =IF(COUNTA(N7,M7,O7,Q7)=0,0,IF(M&-O7,N
(Q7)+N(N7)-1,N(Q7)+N(N7))) now I get a FALSE in my box -
is there someone out there who can help?