Display Value as %

My company uses a formula for the Target % Complete which basically looks at the start and end dates of a task and gives the percentage of work that should have been completed to date. The formula is as follows;

=IF(Start1 <= TODAY(), IF(Finish1 <= TODAY(), 1, NETWORKDAYS(Start1, TODAY()) / INT(Duration1)), 0)

My issue is that using this formula in a new sheet gives the value as a decimal point not a percentage like in other sheets. Could someone help me understand where I am going wrong with this formula, please?

Find more posts tagged with

Accepted answers

All comments

Ramzi K

Daniel, try changing the format for the cell (or column) to % format using the toolbar.

Hope that helps.

Ramzi

Daniel Barber

So simple and I completely overlooked it! Thank you!

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.