| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formulas and making info invisible
I have created a data base where I am substracting dates
for payment purposes - if there are any services on any day a full 24 hour day has to be paid for - but when I subtract the dates and put in for example 03/03/04 - 03/03/04 - instead of getting one day I get 0 -- I tried adding 1 to the formulat but came up with a more serious problem - those people I don't have to pay and should have a 0 now have a one - can you help me - HELP PLEASE - is there a way to program excell to understand? Katherine |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Formulas and making info invisible
Hi
how do you identify the people you don't have to pay? -- Regards Frank Kabel Frankfurt, Germany "Katherine" schrieb im Newsbeitrag ... I have created a data base where I am substracting dates for payment purposes - if there are any services on any day a full 24 hour day has to be paid for - but when I subtract the dates and put in for example 03/03/04 - 03/03/04 - instead of getting one day I get 0 -- I tried adding 1 to the formulat but came up with a more serious problem - those people I don't have to pay and should have a 0 now have a one - can you help me - HELP PLEASE - is there a way to program excell to understand? Katherine |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Formulas and making info invisible -
Frank -
\Frank I have it set up as follows Column A Columm B Column C 03/03/04 03/03/04 0 blank blank 0 if I add one to my formula - I get blank blank 1 and I might end up paying someone I shouldn't right now this is how it reads if I have to date it also reads 0 so I know I pay nothing but Column C isn't correct because I have to pay for one day of service - the day of 03/03/04 any suggestions thank you in advance Katherine -----Original Message----- Hi how do you identify the people you don't have to pay? -- Regards Frank Kabel Frankfurt, Germany "Katherine" schrieb im Newsbeitrag ... I have created a data base where I am substracting dates for payment purposes - if there are any services on any day a full 24 hour day has to be paid for - but when I subtract the dates and put in for example 03/03/04 - 03/03/04 - instead of getting one day I get 0 -- I tried adding 1 to the formulat but came up with a more serious problem - those people I don't have to pay and should have a 0 now have a one - can you help me - HELP PLEASE - is there a way to program excell to understand? Katherine . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Formulas and making info invisible -
=if(and(A2="",B2=""),0,B2-A2+1)
-- Regards, Tom Ogilvy "Katherine" wrote in message ... Frank - \Frank I have it set up as follows Column A Columm B Column C 03/03/04 03/03/04 0 blank blank 0 if I add one to my formula - I get blank blank 1 and I might end up paying someone I shouldn't right now this is how it reads if I have to date it also reads 0 so I know I pay nothing but Column C isn't correct because I have to pay for one day of service - the day of 03/03/04 any suggestions thank you in advance Katherine -----Original Message----- Hi how do you identify the people you don't have to pay? -- Regards Frank Kabel Frankfurt, Germany "Katherine" schrieb im Newsbeitrag ... I have created a data base where I am substracting dates for payment purposes - if there are any services on any day a full 24 hour day has to be paid for - but when I subtract the dates and put in for example 03/03/04 - 03/03/04 - instead of getting one day I get 0 -- I tried adding 1 to the formulat but came up with a more serious problem - those people I don't have to pay and should have a 0 now have a one - can you help me - HELP PLEASE - is there a way to program excell to understand? Katherine . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Formulas and making info invisible -
Hi
try the following in C1: =IF(OR(A1="",B1=""),0,B1-A1+1) -- Regards Frank Kabel Frankfurt, Germany "Katherine" schrieb im Newsbeitrag ... Frank - \Frank I have it set up as follows Column A Columm B Column C 03/03/04 03/03/04 0 blank blank 0 if I add one to my formula - I get blank blank 1 and I might end up paying someone I shouldn't right now this is how it reads if I have to date it also reads 0 so I know I pay nothing but Column C isn't correct because I have to pay for one day of service - the day of 03/03/04 any suggestions thank you in advance Katherine -----Original Message----- Hi how do you identify the people you don't have to pay? -- Regards Frank Kabel Frankfurt, Germany "Katherine" schrieb im Newsbeitrag ... I have created a data base where I am substracting dates for payment purposes - if there are any services on any day a full 24 hour day has to be paid for - but when I subtract the dates and put in for example 03/03/04 - 03/03/04 - instead of getting one day I get 0 -- I tried adding 1 to the formulat but came up with a more serious problem - those people I don't have to pay and should have a 0 now have a one - can you help me - HELP PLEASE - is there a way to program excell to understand? Katherine . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Making a 0 invisible with a formiula | Excel Discussion (Misc queries) | |||
| Making a drop down list read info from another tab / worksheet | New Users to Excel | |||
| Info from one cell making other cells active | Excel Worksheet Functions | |||
| Making Border of Frozen Panes Invisible | Excel Discussion (Misc queries) | |||
| Making info appear in another cell | Excel Discussion (Misc queries) | |||
![Katherine[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
