Formula Help

Hello,

I feel like I am close with the current formula I am using in a build out. Could use some help if anyone has suggestions.

I have a section where AutoFail is possible and then a Section that is Pass/Fail based on %'s.

If they Pass the Pass/Fail Portion but Auto Fail the other portion the entire total score is Auto Fail. If they Pass the Auto Fail portion but Fail the Pass/Fail area, then the return should be Fail.

I am currently using this formula:

=IF([Auto Fail Total]@row =0, "AUTO FAIL", IF([Pass/Fail %]@row >= 0.6, "PASS", IF([Pass/Fail %]@row < 0.6, "FAIL")))

The only part it is not returning when I run tests is the Fail if the score is below 60%.

Any help would be greatly appreciated.

Find more posts tagged with

Formulas

help

Accepted answers

Bryce Jablonski

For anyone else who may need it the formula that ended up working is listed below.

=IF([Auto Fail Total]@row = 0, "AUTO FAIL", IF(AND([Total Score 60%=Passing]@row >= 0.6), "PASS", "FAIL"))

All comments

Larry

Try saving & refreshing, I see no issues when using the formula you provided.

Bryce Jablonski

Hey Larry,

I tried saving and refreshing and it is still showing pass when it should be showing fail with a total % score below 60% and they did not auto fail.

Thanks for saying you see no issue when using the formula I provided.

I am super confused on why the formula would not be working correctly especially with another set of eyes on it.

I may just leave it alone for a day and see if it starts to work properly. I know that might be a long shot but may be worth it.

If I hear or get other responses on formulas, I will try those as well to see what happens.

Bryce Jablonski

For anyone else who may need it the formula that ended up working is listed below.

=IF([Auto Fail Total]@row = 0, "AUTO FAIL", IF(AND([Total Score 60%=Passing]@row >= 0.6), "PASS", "FAIL"))

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.