Formula Help

Bryce Jablonski

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.

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"))

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"))