IF OR Formula

I’m creating a symbol field with colors red, yellow and green for risk level. But I have two different totals columns (because we’re either looking at two separate sets of factors to assess risk - we will have a score for either one factor or the other). So I want to write a formula that says IF Cell A or Cell B cell is >10, red; IF Cell A or Cell B is <6, green; otherwise, yellow.
This is what I have so far:
=IF(OR([FDP Findings Risk Score]@row > 10, [Risk Score]@row > 10), "Red", IF(OR([FDP Findings Risk Score]@row < 6, [Risk Score]@row < 6), "Green", "Yellow"))
My symbol cell will turn red or green according to my score, but not yellow.
Any help would be greatly appreciated!
Answers
-
Are you able to provide some screenshots of the rows that show each of the different colors (including the missing yellow)?
-
I had a coworker help me get it right, and this was her answer:
Ok, I think I got it. I think the issue was that we had the logic out of order. We want the red condition first, then yellow, and then default to green. Let me know if this works, if not we will work until we find the right solution! I’m happy to chat about it either way, if you would like.
=IF(OR([FDP Findings Risk Score]@row > 10, [Risk Score]@row > 10), "Red", IF(AND([FDP Findings Risk Score]@row > 5, [FDP Findings Risk Score]@row < 11), "Yellow", IF(AND([Risk Score]@row > 5, [Risk Score]@row < 11), "Yellow", "Green")))
-
The way the logic reads should work, but the way the logic in the first one read I thought should be working as well.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!