Apr 26 2021 11:33 PM
Hi,
I have a calculated column in a list as below;
=IF([Slope (%)]>"90","PASS","FAIL")
It works except for when the result is 100 - now it should say PASS as 100 is greater than 90 but it shows as FAIL.
Any ideas why it's doing this and how I can sort it?
Apr 27 2021 06:38 AM
Solution@RRMX01 If the data type of your [Slope (%)] column is Single line of text then your formula will fails as you are comparing text in your formula.
Solution 1: If you want to continue using single line of text for Slope %, use below formula for calculated column:
=IF(Value([Slope (%)]) > 90, "PASS", "FAIL")
Output:
Solution 2: Use Number data type for Slope (%) column & use below formula:
=IF([Slope (%)] > 90, "PASS", "FAIL")
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
Apr 27 2021 06:38 AM
Solution@RRMX01 If the data type of your [Slope (%)] column is Single line of text then your formula will fails as you are comparing text in your formula.
Solution 1: If you want to continue using single line of text for Slope %, use below formula for calculated column:
=IF(Value([Slope (%)]) > 90, "PASS", "FAIL")
Output:
Solution 2: Use Number data type for Slope (%) column & use below formula:
=IF([Slope (%)] > 90, "PASS", "FAIL")
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.