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"))))))

Find more posts tagged with

Accepted answers

Mark Rojas

@Matthew Bertucci

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

All comments

Mark Rojas

@Matthew Bertucci

~MR

Matthew Bertucci

Thanks Mark, I had to roundup the months column and then it worked! Thanks so much for the prompt response and help!

Mark Rojas

Happy to Help!

~MR

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.