Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nesting Networkdays function inside and If function
Hello - I'm working on a massive payroll analysis. I'm wondering if it's
possible to nest a networdays inside of an if function. I pasted a formula below that I'm using for the IF portion. I'd like to replace the H5-H4 portion (which represent the start and stop dates) with the networkdays function. =IF(A5=A4,H5-H4,105366-H4) Thanks so much. -- Addison |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nesting Networkdays function inside and If function
Try it!
=IF(A5=A4,NETWORKDAYS(H4,H5),105366-H4) -- Kind regards, Niek Otten "Addison" wrote in message ... Hello - I'm working on a massive payroll analysis. I'm wondering if it's possible to nest a networdays inside of an if function. I pasted a formula below that I'm using for the IF portion. I'd like to replace the H5-H4 portion (which represent the start and stop dates) with the networkdays function. =IF(A5=A4,H5-H4,105366-H4) Thanks so much. -- Addison |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nesting Networkdays function inside and If function
Wouldn't it have been simpler to try it than to post the question?
Confused! "Addison" wrote in message ... Hello - I'm working on a massive payroll analysis. I'm wondering if it's possible to nest a networdays inside of an if function. I pasted a formula below that I'm using for the IF portion. I'd like to replace the H5-H4 portion (which represent the start and stop dates) with the networkdays function. =IF(A5=A4,H5-H4,105366-H4) Thanks so much. -- Addison |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I use a Reference inside a SUMIF or COUNTIF Function? | Excel Worksheet Functions | |||
Using a range variable inside a excel function | Excel Discussion (Misc queries) | |||
SUMIF Function Inside SUMPRODUCT Function | Excel Worksheet Functions | |||
How protect function inside cell from change | Excel Discussion (Misc queries) | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions |