Help on IF formula... validating two columns.
Hi, hope everyone is doing well? hoping someone could please help me with this formula, at the moment I am using the below formula to check the % from Score column and give the outcome result in the Result column and this is working fine, just wondering, if there a way I can include ‘Auto Fail’ in the above formula so if Autofail column is ‘Y’ then it will show Result as ‘Auto Fail’ in the Result column?
Many Thanks,
=IF([Score]@row < 0.5, "Fail", IF(AND([Score]@row > 0.5, [Score]@row < 0.65), "Pass", IF(AND([Score]@row > 0.64, [Score]@row < 0.75), "Credit", IF(AND([Score]@row > 0.74, Score]@row < 0.85), "Distinction", IF(AND([Score]@row > 0.84, [Score]@row <= 1), "High Distinction")))))
Ex: In the above table, Row2 and Row5 Autofail column is 'Y' so i want the Result to show as 'Auto Fail' in Result column.
Score <50% = Fail
Score >50% and <65% = Pass
Score >64% and <75% = Credit
Score >74% and < 85% = Distinction
Score >84% and <=100% = High Distinction
Autofail = ‘Y’ then Auto Fail to show in Result column.
Best Answers
-
Try this one:
=IF([Autofail]@row = "Y", "Auto Fail", IF([Score]@row < 0.5, "Fail", IF(AND([Score]@row > 0.5, [Score]@row < 0.65), "Pass", IF(AND([Score]@row > 0.64, [Score]@row < 0.75), "Credit", IF(AND([Score]@row > 0.74, Score]@row < 0.85), "Distinction", IF(AND([Score]@row > 0.84, [Score]@row <= 1), "High Distinction"))))))
-
This should work for you:
=IF(Autofail@row = "Y", "Auto Fail", IF(Score@row< 0.5, "Fail", IF(Score@row< 0.65, "Pass", IF(Score@row< 0.75, "Credit", IF(Score@row<0.85, "Distinction", "High Distinction")))))
Answers
-
Try this one:
=IF([Autofail]@row = "Y", "Auto Fail", IF([Score]@row < 0.5, "Fail", IF(AND([Score]@row > 0.5, [Score]@row < 0.65), "Pass", IF(AND([Score]@row > 0.64, [Score]@row < 0.75), "Credit", IF(AND([Score]@row > 0.74, Score]@row < 0.85), "Distinction", IF(AND([Score]@row > 0.84, [Score]@row <= 1), "High Distinction"))))))
-
This should work for you:
=IF(Autofail@row = "Y", "Auto Fail", IF(Score@row< 0.5, "Fail", IF(Score@row< 0.65, "Pass", IF(Score@row< 0.75, "Credit", IF(Score@row<0.85, "Distinction", "High Distinction")))))
-
Hi, @Paul Newcome @Carson Penticuff Thank you so much for your help it did work. ☺️
Appreciate your time Thanks once again.. Have a good day!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!