| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula Question
I am new to all of this and am having a VERY difficult time getting a formula
which explains the following: if E6 is BLANK then G6=0. I am working with dates and my spreadsheet is calculating a negative number unless the "date field" is populated. Anyone help me out there?? Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Formula Question
In G6:
=IF(E6="",0,something_else) -- Gary's Student gsnu200703 "Lesa" wrote: I am new to all of this and am having a VERY difficult time getting a formula which explains the following: if E6 is BLANK then G6=0. I am working with dates and my spreadsheet is calculating a negative number unless the "date field" is populated. Anyone help me out there?? Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Formula Question
enter in G6
=IF(E6="",0,D6-B6) This is assuming that the existing formual in G6 is something like =D6-B6 -- Greetings from New Zealand "Lesa" wrote in message ... I am new to all of this and am having a VERY difficult time getting a formula which explains the following: if E6 is BLANK then G6=0. I am working with dates and my spreadsheet is calculating a negative number unless the "date field" is populated. Anyone help me out there?? Thanks! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Formula Question
Thanks, Gary's Student. G6 no longer shows a negative number, but it now
populated with "FALSE", how do I get this to reflect "0"? Thanks! "Gary''s Student" wrote: In G6: =IF(E6="",0,something_else) -- Gary's Student gsnu200703 "Lesa" wrote: I am new to all of this and am having a VERY difficult time getting a formula which explains the following: if E6 is BLANK then G6=0. I am working with dates and my spreadsheet is calculating a negative number unless the "date field" is populated. Anyone help me out there?? Thanks! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Formula Question
Hi Bill!
I guess I'd better show the actual formula I'm using and trying to revise: =NETWORKDAYS(C6,E6) It is to show how many net working days between 2 dates. So, C6 = 12/01/06, and I do not have E6 populated, (it is blank) so my SUM in G6 = -27895. I want this to show as "0". Is this possible??? Thanks all! "Bill Kuunders" wrote: enter in G6 =IF(E6="",0,D6-B6) This is assuming that the existing formual in G6 is something like =D6-B6 -- Greetings from New Zealand "Lesa" wrote in message ... I am new to all of this and am having a VERY difficult time getting a formula which explains the following: if E6 is BLANK then G6=0. I am working with dates and my spreadsheet is calculating a negative number unless the "date field" is populated. Anyone help me out there?? Thanks! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Formula Question
=IF(E6="",0,NETWORKDAYS(C6,E6))
should work ok. it does on this side of the globe. :) Greetings from New Zealand "Lesa" wrote in message ... Hi Bill! I guess I'd better show the actual formula I'm using and trying to revise: =NETWORKDAYS(C6,E6) It is to show how many net working days between 2 dates. So, C6 = 12/01/06, and I do not have E6 populated, (it is blank) so my SUM in G6 = -27895. I want this to show as "0". Is this possible??? Thanks all! "Bill Kuunders" wrote: enter in G6 =IF(E6="",0,D6-B6) This is assuming that the existing formual in G6 is something like =D6-B6 -- Greetings from New Zealand "Lesa" wrote in message ... I am new to all of this and am having a VERY difficult time getting a formula which explains the following: if E6 is BLANK then G6=0. I am working with dates and my spreadsheet is calculating a negative number unless the "date field" is populated. Anyone help me out there?? Thanks! |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Formula Question
You ROCK, Bill!!!
Many many thanks from Snowy Minnesota, to you in Sunny New Zealand! "Bill Kuunders" wrote: =IF(E6="",0,NETWORKDAYS(C6,E6)) should work ok. it does on this side of the globe. :) Greetings from New Zealand "Lesa" wrote in message ... Hi Bill! I guess I'd better show the actual formula I'm using and trying to revise: =NETWORKDAYS(C6,E6) It is to show how many net working days between 2 dates. So, C6 = 12/01/06, and I do not have E6 populated, (it is blank) so my SUM in G6 = -27895. I want this to show as "0". Is this possible??? Thanks all! "Bill Kuunders" wrote: enter in G6 =IF(E6="",0,D6-B6) This is assuming that the existing formual in G6 is something like =D6-B6 -- Greetings from New Zealand "Lesa" wrote in message ... I am new to all of this and am having a VERY difficult time getting a formula which explains the following: if E6 is BLANK then G6=0. I am working with dates and my spreadsheet is calculating a negative number unless the "date field" is populated. Anyone help me out there?? Thanks! |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Formula Question
Thanks for the feed-back Lesa
Your summer will come again this year, promise......... Bill "Lesa" wrote in message ... You ROCK, Bill!!! Many many thanks from Snowy Minnesota, to you in Sunny New Zealand! "Bill Kuunders" wrote: =IF(E6="",0,NETWORKDAYS(C6,E6)) should work ok. it does on this side of the globe. :) Greetings from New Zealand "Lesa" wrote in message ... Hi Bill! I guess I'd better show the actual formula I'm using and trying to revise: =NETWORKDAYS(C6,E6) It is to show how many net working days between 2 dates. So, C6 = 12/01/06, and I do not have E6 populated, (it is blank) so my SUM in G6 = -27895. I want this to show as "0". Is this possible??? Thanks all! "Bill Kuunders" wrote: enter in G6 =IF(E6="",0,D6-B6) This is assuming that the existing formual in G6 is something like =D6-B6 -- Greetings from New Zealand "Lesa" wrote in message ... I am new to all of this and am having a VERY difficult time getting a formula which explains the following: if E6 is BLANK then G6=0. I am working with dates and my spreadsheet is calculating a negative number unless the "date field" is populated. Anyone help me out there?? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Date Formula Question | Excel Discussion (Misc queries) | |||
| excel division formula question | Excel Worksheet Functions | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Excel auto calculation formula question. | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
