IF Formula w/ multiple conditions

[RLJ]

I need the formula in column D to be modified so that when both Column C and E are blank, then Column D is also blank.

Book1
	A	B	C	D	E
1	Todays Date	3/7/2024
2
3
4	Widget #	Widget type	Assigned Date	Days from Assignment	Completed
5	1	Metal	2/29/2024		3/7/2024
6	2	Wood	3/1/2024	5
7	3	Plastic		32399
Sheet1

Cell Formulas
Range	Formula
B1	B1	=TODAY()
D5:D7	D5	=IF(E5="",NETWORKDAYS(C5,$B$1),"")

Thank you for your help

 

[Asbestos_Jen]

Try this:

=IF(AND(C5="",E5=""),NETWORKDAYS(C5,$B$1),"")

 

[RLJ]

Try this:

=IF(AND(C5="",E5=""),NETWORKDAYS(C5,$B$1),"")

This formula still gives the same result as the example spreadsheet cell D7.

 

[Fluff]

Try it like

=IF(AND(C5="",E5=""),"",NETWORKDAYS(C5,$B$1))

 

[RLJ]

Try it like

=IF(AND(C5="",E5=""),"",NETWORKDAYS(C5,$B$1))

Looks Like this works. Thank you

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Peter_SSs]

Looks Like this works. Thank you

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.