Help with Nested Formula
Hello, I've got the below formula to sorta work, but the problem is that it is not giving me a return if my value falls outside of the last formula (>500). I even tried the second formula, but it put everything to 5 no matter what. See screenshot below (1st formula). Thanks in advance.
=IF(Lipemia@row < 40, "0", IF(Lipemia@row = 40  99, "1", IF(Lipemia@row = 100  199, "2", IF(Lipemia@row = 200  299, "3", IF(Lipemia@row = 300  500, "4", IF(Lipemia@row > 500, "5"))))))
=IF(Lipemia@row < 40, "0", IF(Lipemia@row = 40  99, "1", IF(Lipemia@row = 100  199, "2", IF(Lipemia@row = 200  299, "3", IF(Lipemia@row = 300  500, "4", "5")))))
Carol
Answers

Try this:
=IF(Lipemia@row < 40, "0", IF(Lipemia@row < 100, "1", IF(Lipemia@row < 200, "2", IF(Lipemia@row < 300, "3", IF(Lipemia@row <= 500, "4", IF(Lipemia@row > 500, "5"))))))

@Steve Rohrdanz Thank you! I was spinning my wheels and this worked perfectly!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 349 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!