% Schedule Complete Calculation

I am using a formula to calculate the % schedule complete based on project start and end date.

=(NETWORKDAYS([Start Date]1, TODAY(), Holidays2:Holidays10)) / (NETWORKDAYS([Start Date]1, [End Date]1, Holidays2:Holidays10))

Is there a way to get this formula to just return 100% if the % complete is above 100%?

Find more posts tagged with

Accepted answers

All comments

Carson Penticuff

Try this:

=IF((NETWORKDAYS([Start Date]1, TODAY(), Holidays2:Holidays10)) / (NETWORKDAYS([Start Date]1, [End Date]1, Holidays2:Holidays10)) > 1, 1, (NETWORKDAYS([Start Date]1, TODAY(), Holidays2:Holidays10)) / (NETWORKDAYS([Start Date]1, [End Date]1, Holidays2:Holidays10)))

jmyzk_cloudsmart_jp

Hi @Rachel Kelly

I would use the IF syntax.

"=IF( Your Formula >= 1, 1, Your Formula)"

=IF((NETWORKDAYS([Start Date]1, TODAY(), Holidays2:Holidays10)) / (NETWORKDAYS([Start Date]1, [End Date]1, Holidays2:Holidays10))>=1,1,(NETWORKDAYS([Start Date]1, TODAY(), Holidays2:Holidays10)) / (NETWORKDAYS([Start Date]1, [End Date]1, Holidays2:Holidays10)))

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.