using IF to skip

  • Thread starter Thread starter Julie
  • Start date Start date
J

Julie

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
 
=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
 
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
 
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
 
thank you so much

Rick Rothstein (MVP - VB) said:
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
Click to expand...
 
Back
Top