IF formula not working

kkinman
✭
This seems to be a really basic formula I'm working on, but the result is only returning red for some reason. Can someone explain why other results might not be returning?
=IF([% Complete]@row < 70, "Red", IF([% Complete]@row = 100, "Green", "Yellow"))
Answers
-
I would assume that your % Complete column is percentage formatted so the value is actually in decimals (so 70 is really .7), your formula would need to be:
=IF([% Complete]@row < .7, "Red", IF([% Complete]@row = 1, "Green", "Yellow"))
-
Just seeing this reply, thank you so much!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.4K Get Help
- 430 Global Discussions
- 152 Industry Talk
- 492 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 76 Community Job Board
- 504 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives