Combine if ISBLANK in an existing formula that pulls percent complete based on duration

Ryan Jared

I have the formula that pull the percentage complete based on the duration between 2 dates

=IF([Start Date]@row <= TODAY(), NETWORKDAYS([Start Date]@row, MIN(TODAY(), [End Date]@row)) / Duration@row, 0)

What I'm trying to do is add the formula below to make a combined formula. Which should make the number zero if there is no date added.

=IF(ISBLANK([Start Date]@row), "0")

Any thoughts?

Paul Newcome

You would drop the first IF in the third portion of the second IF to create a nest IF statement.

=IF(logical statement, value if true, value if false)

Basically you want it to run the first logical statement. If that is true then you have your output. If the first logical statement is false then you want to run another IF statement.

Paul Newcome

You would drop the first IF in the third portion of the second IF to create a nest IF statement.

=IF(logical statement, value if true, value if false)

Basically you want it to run the first logical statement. If that is true then you have your output. If the first logical statement is false then you want to run another IF statement.

Ryan Jared

That did the trick, Thanks @Paul Newcome

Paul Newcome

Happy to help. 👍️