% in formula issue

Good morning,

I have a column which named "% Complete". The next column, I wrote:

=IF([% Complete]@row = 100, "Complete", "Not Complete")

That works if the % complete column is 100. But it doesn't work if I turn the "% Complete" column into a percentage format. How do I tweak my formula to state that if it's "100%", it's complete.

If I add the % symbol:

=IF([% Complete]@row = 100%, "Complete", "Not Complete") → unparseable

Thanks all

Find more posts tagged with

Formulas

Accepted answers

Protonsponge

Hello @MBurdman

I think the following formula will work for you - replacing 100 with 1 when your column is formatted as a percentage.

=IF([% Complete]@row = 1, "Complete", "Not Complete")

I hope that is helpful to you in someway,

Protonsponge

All comments

Protonsponge

Hello @MBurdman

I think the following formula will work for you - replacing 100 with 1 when your column is formatted as a percentage.

=IF([% Complete]@row = 1, "Complete", "Not Complete")

I hope that is helpful to you in someway,

Protonsponge

MBurdman

Yep! That worked. Thanks so much.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.