If Statement to Group Notice Dates by 0-3,4-6,7-11,12-18, 18+

Matthew Bertucci

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

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

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

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