If, or statement for percentage

I have this formula =IF(OR([Standard Phase/ current status]@row = "4", (([Phase \[%\]]@row * 0.25) + 75)), [Standard Phase/ current status]@row = "3", (([Phase \[%\]]@row * 0.25) + 50), [Standard Phase/ current status]@row = "2", (([Phase \[%\]]@row * 0.25) + 25), [Standard Phase/ current status]@row = "1", ([Phase \[%\]]@row * 0.25))

If Standard phase is 3, the calculation should be 50% + the percentage of stage complete in phase 3 *0.25

This is a 4 stage process and each stage has percentage of 25% when it is completed which is then to be added to the next stage finish percentage.

This formula gives me incorrect argument

Find more posts tagged with

Accepted answers

All comments

Intern98

=IF([Standard Phase/ current status]@row = 4,([Phase \[%\]]@row * 0.25) + 75),

IF([Standard Phase/ current status]@row = 3,([Phase \[%\]]@row * 0.25) + 50),

IF([Standard Phase/ current status]@row = 2,([Phase \[%\]]@row * 0.25) + 25),

IF([Standard Phase/ current status]@row = 1,([Phase \[%\]]@row * 0.25),"")

Daxal

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.