If Statement to Group Notice Dates by 0-3,4-6,7-11,12-18, 18+
Hi, Looking for help please. I'm sure its some easy but I'm missing something. The formula works for 0-3 and 4-6 but not the rest.
=IF([Months to Notice Date]@row <= 3, "0-3 months", IF(OR([Months to Notice Date]@row >= 4, [Months to Notice Date]@row <= 6), "4-6 Months", IF(OR([Months to Notice Date]@row >= 7, [Months to Notice Date]@row <= 12, "7-12 Months", IF(OR([Months to Notice Date]@row > 12, "13-18 Months"))))))
Best Answer
-
Try this: =IF([months to notice date]@row > 12, "13-18 months", IF(AND([months to notice date]@row >= 7, [months to notice date]@row <= 12), "7-12 Months", IF(AND([months to notice date]@row >= 4, [months to notice date]@row <= 6), "4-6 months", IF([months to notice date]@row <= 3, "0-3 months"))))
~MR
Answers
-
Try this: =IF([months to notice date]@row > 12, "13-18 months", IF(AND([months to notice date]@row >= 7, [months to notice date]@row <= 12), "7-12 Months", IF(AND([months to notice date]@row >= 4, [months to notice date]@row <= 6), "4-6 months", IF([months to notice date]@row <= 3, "0-3 months"))))
~MR
-
Thanks Mark, I had to roundup the months column and then it worked! Thanks so much for the prompt response and help!
-
Happy to Help!
~MR
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!