Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using IF to skip
I am using =NETWORKDAYS(B23,B29)-1 as one of my formulas. I have the -1
because I am tracking several different time frames going from one place to another and without the -1 it is counting a day twice. I need this formula in every cell that has the days, but there won't be a time span every time. When there's no time span i get a -1 in the cell which is messing up count. Is there a way to add an IF function to the function above that says If -1 then skip? or count as 0? I've tried several different ways and it's not working. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using IF to skip
=IF(NETWORKDAYS(B23,B29)-1=-1,0,NETWORKDAYS(B23,B29)-1)
=IF(NETWORKDAYS(B23,B29)-1=-1,"",NETWORKDAYS(B23,B29)-1) The first formula returns 0 for the -1 and the second formula returns the empty string Tyro "Julie" wrote in message ... I am using =NETWORKDAYS(B23,B29)-1 as one of my formulas. I have the -1 because I am tracking several different time frames going from one place to another and without the -1 it is counting a day twice. I need this formula in every cell that has the days, but there won't be a time span every time. When there's no time span i get a -1 in the cell which is messing up count. Is there a way to add an IF function to the function above that says If -1 then skip? or count as 0? I've tried several different ways and it's not working. Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using IF to skip
This formula will let the calculation take place only if both B23 and B29
have entries in them... =IF(OR(B23="",B29=""),"",NETWORKDAYS(B23,B29)-1) Rick "Julie" wrote in message ... I am using =NETWORKDAYS(B23,B29)-1 as one of my formulas. I have the -1 because I am tracking several different time frames going from one place to another and without the -1 it is counting a day twice. I need this formula in every cell that has the days, but there won't be a time span every time. When there's no time span i get a -1 in the cell which is messing up count. Is there a way to add an IF function to the function above that says If -1 then skip? or count as 0? I've tried several different ways and it's not working. Thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using IF to skip
And if you want the calculation to take place as long as both are not blank
(which is really what your original question asked)... =IF(AND(B23="",B29=""),"",NETWORKDAYS(B23,B29)-1) although I would wonder at the usefulness of an answer if one of the cells were blank (hence my original answer). Rick "Rick Rothstein (MVP - VB)" wrote in message ... This formula will let the calculation take place only if both B23 and B29 have entries in them... =IF(OR(B23="",B29=""),"",NETWORKDAYS(B23,B29)-1) Rick "Julie" wrote in message ... I am using =NETWORKDAYS(B23,B29)-1 as one of my formulas. I have the -1 because I am tracking several different time frames going from one place to another and without the -1 it is counting a day twice. I need this formula in every cell that has the days, but there won't be a time span every time. When there's no time span i get a -1 in the cell which is messing up count. Is there a way to add an IF function to the function above that says If -1 then skip? or count as 0? I've tried several different ways and it's not working. Thanks |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using IF to skip
thank you so much
"Rick Rothstein (MVP - VB)" wrote: This formula will let the calculation take place only if both B23 and B29 have entries in them... =IF(OR(B23="",B29=""),"",NETWORKDAYS(B23,B29)-1) Rick "Julie" wrote in message ... I am using =NETWORKDAYS(B23,B29)-1 as one of my formulas. I have the -1 because I am tracking several different time frames going from one place to another and without the -1 it is counting a day twice. I need this formula in every cell that has the days, but there won't be a time span every time. When there's no time span i get a -1 in the cell which is messing up count. Is there a way to add an IF function to the function above that says If -1 then skip? or count as 0? I've tried several different ways and it's not working. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
skip to worksheet | Excel Worksheet Functions | |||
Can I skip all these questions? | Excel Discussion (Misc queries) | |||
If false skip to next | Excel Worksheet Functions | |||
Skip Over Blanks | Excel Discussion (Misc queries) | |||
Skip a day of the week | Excel Discussion (Misc queries) |