| Home |
| Search |
| Today's Posts |
|
|
|
#1
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) | |||
Hybrid Mode
