Adding IF to a formula with IFERROR

deb_63_hydracor

I'm using the following formula (which works because you all helped me with it!)

=IFERROR(NETDAYS([Date of Verbal Agreement]@row, TODAY()), "")

I need to add "if the "Deployment Complete" box is unchecked but have no idea where to put it in the formula.

Thanks for your help!

Michael Culley

=if([deployment complete]@row = 0,IFERROR(NETDAYS([Date of Verbal Agreement]@row, TODAY()), ""))

Does that work?

Michael Culley

=if([deployment complete]@row = 0,IFERROR(NETDAYS([Date of Verbal Agreement]@row, TODAY()), ""))

Does that work?